Vlookup Lookup. The column number in the range that contains the return value. The second argument is the range of cells c2 e7 in which to search for the value you want to find.
For example look for this piece of information in the following area and give me some corresponding data in another column. Is similar but only allows a user to search vertically in a row and only returns data in a left to right procedure. If the data is organized horizontally and you want to count down the rows to retrieve the value you can use the hlookup function.
Function vlookup lookup value table range column number.
The second argument is the range of cells c2 e7 in which to search for the value you want to find. For example look for this piece of information in the following area and give me some corresponding data in another column. The second argument is the range of cells c2 e7 in which to search for the value you want to find. Is similar but only allows a user to search vertically in a row and only returns data in a left to right procedure.