An other important difference between vlookup and index&match is that
when using vlookup the look-up value needs to be in the leftmost
column.

Index&match doe not require that.

ie vlookup:

Col A Col B Col C
1 A HI
2 B Bye
3 C Yes
4 D No

If your lookup value was in Col B (lets say "B"), you could not look up
values form Col A ("2")

You could do it with index & match though.


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=542246