Hi

An example:

You have a sheet Employees with columns:
Empname, Occupation, BirthDate, Sex

with data in range A2:D100,
and with a row for every employee.

On other sheet, in cell A2 you have employees name, listed in sheet
Employees, and you want to retrieve p.e. employees birthday. The formula
will be:
=VLOOKUP(A1,Employees!$A$2:$D$100,3,0)
I.e. you look for exact match (4th parameter is 0 or FALSE) of value from
cell A1 (1st parameter) in range Employees!A2:D100 (2nd parameter), and
return value from 3rd column of lookup range (3rd parameter - points to
column BirthDate) on same row of lookup range.


Arvi Laanemets


"MacNut" wrote in message
...
Hi,

I'm trying to lookup a certain column of data in another spreadsheet based
on values that match (empnames) in both spreadsheets, and put those values
into my master spreadsheet I have. The syntax:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

I assume that "lookup_value" is that first column in the master
spreadsheet
(empnames); table_array is the column that houses the values that is in
the
other spreadsheet that I want in the Master one; col_index_num is the
number
of the column that houses that data. Is this correct? I'm getting an
error
saying "#N/A" What am I doing wrong?

Thanks,
MN