VLOOKUP for Microsoft Excel
Monday, March 12th, 2007
To use function vlookup is simple, we just remember how many columns that we have.
column is counted from left to right.
don’t forget to use $ sign to make absolute value by pressing F4 from keyboard.
remember when we make a table for vlookup function, the columm key for lookup_value should be sorted ascendingly, otherwise we will see unexpected result.
if we see the picture that we have, so the correct formulas are:
=VLOOKUP(A2,$A$7:$B$9,2) for column B in cell B2
=VLOOKUP(A2,$A$7:$C$9,3) for column C in cell C2
Copy the formula to fill next row.