Sounds like a simple vlookup function to me.

=vlookup(A1,"Page2 A1:A2",2,0)


--
PowerWheels
------------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045
View this thread: http://www.excelforum.com/showthread...hreadid=497398