Use VLOOKUP on sheet 1. Let's assume your data is in Cols A:B on sheet2
and Col A on sheet1, both beginning in row 1 through row 25.
On sheet1, in B1 place this formula:
=VLOOKUP(A1,Sheet1!$A$1:$A$25,2,0)
then copy this formula down through B25
Good Luck
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=375625