Vlookup Function. This article will assume that the reader already has a passing understanding of excel functions and can use basic functions such as sum average and today. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc.
Lookup values must appear in the first column of the table passed into vlookup. For example the vlookup function below looks up mia cell g2 in the leftmost column of the table. Lookup value required argument lookup value specifies the value that we want to look up in the first column of a table.
The alphabet v in vlookup stands for vertical so this function is sometimes also called vertical lookup.
Vlookup what you want to look up where you want to look for it the column number in the range containing the value to return return an approximate or exact match indicated as 1 true or 0 false. Vlookup lookup value table array column index number range lookup the lookup value is the target item you want to check out and this must fall on the first column of your spreadsheet. Lookup values must appear in the first column of the table passed into vlookup. It was created to lookup and retrieve data from a specific column in a table.
