Pages

Showing posts with label vlookup. Show all posts
Showing posts with label vlookup. Show all posts

Tuesday, 15 November 2011

Vlookup Explained!

VLOOKUP(), the Vertical Lookup function, is very useful to sort through a large table of records and find values associated with any column to the RIGHT of your reference column.
For example, in a table of ID NUMBERS and AGE, you can type in an ID NUMBER and find the age of that person easily.
GENERAL SYNTAX is: