|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
VLOOKUP and using a Name in the col_index_num
Beans wrote:
Hi, I am using the VLOOKUP function.
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)
I was wondering if anyone had any success in substitution a name vs the
number of the col_index_num. The reason I ask is I need to add a column to
the spreadsheet that I am evaluating with the VLOOKUP function, and when I
do, I have to redo all the vlookup col_index_num values as they are now
pointing to the wrong column.
Thanks
See if this helps.
http://www.contextures.com/xlFunctio...tml#IndexMatch
|