I have been hoping that I can use VLOOKUP and forget about INDEX and MATCH. :) So, today I am reminded that there are circumstances that I can't use VLOOKUP. I wonder if VLOOKUP is faster.

Learning everyday ......

Epinn

"Carim" wrote in message ups.com...
Hi Epinn,


If I am mistaken, this was at least the rule ....
in order to vlookup "on the left", one had to combine match and index
to come up with the result ...

HTH
Cheers
Carim