M
MacNut
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,range_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
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,range_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