Learn Microsoft Excel Online FreeVLOOKUP function is very strong and we often use this function in our daily life. And we all know that we can use VLOOKUP to get proper value by entering a value which is exactly the same with the lookup value in selected lookup range. If the entered value is not exactly matching the lookup… read more »
We often use VLOOKUP function to find proper value by certain conditions in excel. And we often create a dropdown list to filter value in excel. If you combine these two features together, it can help us solve a lot of search problems by some conditions, and it will bring us a lot of convenience…. read more »
Sometimes we need to merge two tables data from different sheets into one table, for example merge data in sheet2 to sheet1 based on some criteria, how can we do? Except copy data from sheet2 to sheet1 one by one, we have another way to merge data by function VLOOKUP in Excel. First, prepare two… read more »
This post will guide you how to highlight cell if same value exists in another column in Excel. How do I highlight cell if value is present in any cell in another column in Excel 2013/2016. Highlight Cell If Same Value Exists in Another Column Assuming that you have a list of data in range… read more »
This post will guide you how to vlookup values from right to left in your worksheet in excel. How do I look up values to left column with a column in Excel 2013/2016. How to use Vlookup function to extract the corresponding value of the left column in your worksheet in Excel. Lookup Values to… read more »
This 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 »
