Vlookup Sample Data. The usage of the vlookup examples is very easy. Type a comma between each argument.
Vlookup is one of the most useful and important functions in microsoft excel. A vlookup is an excel function that looks for something in a range of cells. Then it returns that something that s in the same row as the value you re looking for.
In other words it allows you to find look up a value from one column of data and returns it s respective or corresponding value from another column.
Remember that excel looks for the lookup value in the left most column. Remember that excel looks for the lookup value in the left most column. Type the first argument lookup value as cell a19 which has the value you want to look up. The alphabet v in vlookup stands for vertical so this function is sometimes also called vertical lookup.