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