Learn Microsoft Excel Online FreePrepare two columns for example column A and column B, column A lists some values, and column B lists some values exist in column A but need to be removed from column A. If we want to exclude these matched values from column A, we can use VLOOKUP function or COUNTIF function here to find… read more »
Suppose we have two lists, list A contains all students, list B only contains students who passed exam. So, list A is longer than list B, and students in list B are all included in list A. If we want to find out which student failed the exam, we can though compare the two list… read more »
VLOOKUP function is very useful in our daily work and we can use it to look up match value in a range, then get proper returned value (the returned value may be just adjacent to the match value). Sometimes we only want to look up the lowest value among all matched values in the list… read more »
VLOOKUP function is extremely strong among excel all functions. We often use it in our work for looking up match value. Sometimes when we autofill VLOOKUP we may get some errors. For most situations that’s because the selected range is entered incorrectly or changed automatically during filling process. This tutorial will help you to enter… read more »
VLOOKUP function is extremely strong among excel all functions and it is very useful in our daily work. It can save a lot of time if we want to find matching value from a long list and return the value we want. Normally we can find exact or approximate matching value from a list by… read more »
VLOOKUP 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 »
