MS excel VLOOKUP

xirokx

xirokx

xirokx

Soldato
Joined
2 Oct 2004
Posts
4,362
Location
N.W London
Hi,

To all ms excel experts

I need to learn the VLOOKUP function religiously because I am working with a lot of spreadsheets...

Does anyone have any tuts? or can they recommend a place I can find them?

Im desperate...

Thanks in advance

Cheers!
 
VLOOKUP is very simple tool for linking values in different tables of information. I might have a list of people's names and addresses in one table, and a separate table of people's names and phone numbers. By searching for their name, i can produce a list of their name with their address and the phone number found from the other table using a vlookup formula.

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

loolup_value is the thing you're searching for, e.g. "A3" will search for the contents of cell A3.

table_array is the range of cells that you want vlookup to search within.

col_index - this chooses how many colums to move to the right once it have found the search value in the table_array range. For example, if it finds the contents of cell A3 in cell S54, and col_index is 3, it will return the contents of cell S56.

Range_lookup lets you choose if you want exact matches or not.

Does that help at all?
 
You must log in or register to reply here.
Back
Top Bottom