VlookUp to Index Match

[paulcherianc]

Hi!

Can anyone convert this formula to Index and match.

=VLOOKUP(B2,Database!$A:$O,2,)

Regards,

 

[AliGW]

Why are you referencing such a huge array when the value you want to return is in the second column???

=INDEX($B:$B,MATCH(B2,$A$A,0))

 

[Chihiro]

Also, for INDEX/MATCH and VLOOKUP, it's always good idea to limit your column range to range that contains data (be it hard coding or via dynamic data range).

Unlike SUMIF, COUNTIF and variants, range isn't shrunk to used range with above formulas and will create unnecessary overhead.

 

[paulcherianc]

Thanks for your kind advice!