Vlookup

[rita]

If afterwards, I insert a column in the "table array"
the "culumn_index_number" in the formula does not change
the number. That means that everytime I insert a column, I
have to change every vlookup on the sheet.
Is there a way round this?

 

[Philip Reece-Heal]

Hi

This might help:
VLOOKUP formula that allows insertion/ deletion of columns that changes
location reference of target:


VLOOKUP(RC[-1],dbase,COLUMN(animal)-(COLUMN(dbase)-1),FALSE)


ie, if table is named dbase and the data you want is in the column named
animal, doesn't matter if no's of columns in dbase change.



I assume you know about naming ranges



All the best



Philip