Hi,

in Sheet Current in Cell C2 :
=INDEX(New!A2:C20,MATCH(A2:A20,New!A2:A20,0),3)

adjust to your needs ...
HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=532774