VLOOKUP function is used when a person is trying to find a piece of information in a large set of data
In the Formula Bar, type =VLOOKUP().
In the parenthesis enter the lookup value followed by a comma. So in the example formula below it would be H3
=VLOOKUP(H3,B3:F25,3,FALSE)
3. Enter the table array. This represents the range of data you want to search where you think the answer is. In the above Example that range is B3:F25.
4. Enter the column index number. This is is the column where you think the answers are and will be to the right of your lookup values. In the above example it's 3.
5. Enter TRUE or FALSE. TRUE for partial matches and FALSE for exact matches.
So lets look at the other full formula....
=VLOOKUP(H2,B3:E9,4,FALSE)
H2 is the lookup value
B3:E9 is the range you want to search
4 is the column index number where you expect the answer to be
FALSE because we want an exact match in our search
Cheers,
The Table Originals team
Comments