Vlookup

  • Thread starter Thread starter rita
  • Start date Start date
R

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?
 
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
 
Back
Top