Saturday, 28 March 2009

How to use VLookUp in Microsoft Excel.

Tool : MS Excel.
Topic : The function - VLOOKUP.

This is a very useful function to extract data from the table.

Microsoft says..
"Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table."

The format.
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)