Learn Microsoft Excel Online FreeThis 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 »
This post will guide you how to repeat cell value N times in Excel. How do I copy cell value N times in Excel. Repeat Cell Value N times Assuming that you have a list of data that contain two column and one column is cell value that you want to repeat, and another column… read more »
This post will guide you how to vlookup a value and then return multiple corresponding values horizontally in Excel. How do I lookup a value and return multiple matched values in the same row in Excel. Or how to return multiple values with VLOOKUP function in Excel. VLOOKUP Return Multiple Values Horizontally Assuming that you… read more »
This post will guide you how to sort the dynamic data automatically in your worksheet. How do I sort dynamic range of data with a formula in Excel. Sort Dynamic Data Assuming that you have a list of data in the range of cells A1:B5, if you want to sort dynamic data in your worksheet,… read more »
