A Simple Computer Library

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.

This entry was posted on Monday, March 12th, 2007 at 9:35 pm and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.