Sorry.. There was a typo in my first quote...

Actually I tried with '2' only..

(ii) =VLOOLUP("Tom",$A2:$D6,2) -- Which should also be same...


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile: http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=314224