making vlookup look left, or adjust when inserting a column

[karate718]

Hi,

This is my formula: =VLOOKUP(AE19,$B$17:$Q$73,16,FALSE)

If I insert a column in between B and Q, the 16 doesn't automatically increase to 17. Is there a way to change this?

Alternatively, is there a way wto make the vlookup look left instead of right. The reason I ask is that the data in column B is duplicated for formatting purposes in column Y and I almost never insert columns between Q and Y.

Thanks.

 

[Domenic]

Try...

=INDEX($Q$17:$Q$73,MATCH(AE19,$Y$17:$Y$73,0))

Hope this helps!

 

[karate718]

Indeed it does. Thank you very much.