col-index is not the number of columns, but rather the column index that you
are interested in. So if the lookup table is of the format empnames,
fullname, age, sex, etc, and you want fullname then col_index would be 2.
Also lookup is set to false if you want an exact match.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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