Vlookup to automatically recognize column to extract from

[efernandes67]

Hi,

Supose I have the example in the attach file.

If I try to "insert" a new column between cols "D" and "E" the vlookup results must remain the same.

How can I do this without changing the formulas?

Regards,
Élio

[NBVC]

Try:

=VLOOKUP(A2,D:E,MATCH("Target",D$1:E$1,0),0)

or

=Index(D:E,Match(A2,D:D,0),MATCH("Target",D$1:E$1,0))

[efernandes67]

Thanks. I works very well.

Regards
Élio