Learn Microsoft Excel Online FreeThis post will guide you how to compare two lists in different worksheets in Excel. How do I compare two lists in different worksheets with VLOOKUP function in Excel 2013/2016. Comparing Two Lists in Different Worksheets Assuming that you have two lists of data in the different worksheets, and you want to compare those two… read more »
This post will guide you how to lookup a value and then return the sum of two or more related columns in Excel 2013/2016. How do I Use VLOOKUP function and SUM function to lookup a specific value and return the sum of all matches in columns in Excel. Vlookup to Return the Sum of… read more »
This post will guide you how to find the largest value in a column and then return the adjacent cell value with a formula in Excel. How do I find the max value and return the cell value from the left adjacent column in Excel. Find the Largest Value and Return the Adjacent Cell Value… read more »
This post will guide you how to compare two columns using VLOOKUP and return values from the third column in Excel. How do I match two columns in Excel and return a value in third column with a formula. Compare Two Columns and Return value in Third Column Assuming that you have two list of… read more »
This post will guide you how to lookup a value from a range of cells and return match from adjacent cell in Excel. How do I Vlookup a value and return a value in corresponding, adjacent cell in Excel. Look up Value and Return Adjacent Cell Value Assuming that you have a list of data… read more »
This post will guide you how get the nth matching values with VLOOKUP function in Excel. How do I find the nth match value with Index/Match formula in Excel. How to find the first, second, third or nth matching value from a range of cells using VLOOKUP formula. Find the First Match Value Using VLOOKUP… read more »
This post will guide you how to vlookup and return blank instead of 0 or #N/A error in Excel. How do I vlookup returning blank instead of 0 or #N/A when no data matched in Excel. Vlookup to Return Blank Instead of 0 or #N/A When you use vlookup function to search a value, and… read more »
This post will guide you how to VLookup and return zero instead of #N/A in Excel. How do I use VLookup function and return zero instead of #N/A if not found in Excel. How to display zero instead of #N/A when using VLOOKUP in Excel. How to replace #N/A with Zero when VLOOKUP. VLOOKUP Returns… read more »
This post will guide you how to find unique values in two columns in Excel. How do I find unique values between two columns with a formula in Excel. How to display only unique values from two columns in Excel. Find Unique Values Assuming that you have a list of data in two different columns… read more »
This post will guide you how to check if one value in a column exists in another column in Excel. How do I check if value in column A exists in Column B with a formula in Excel. How to determine if values exists in another column in Excel. Check If Value in a Column… read more »
