Hi,
you can use vlookup to help you do that.
Assuming that sheet 1 looks like this

col A
1234
5678

and sheet 2 looks like this

col A-------col B------col C
1234--------12------room
5678--------24------fridge

in B1 on sheet 1 put this as the formula

=VLOOKUP(A1,Sheet2!A1:C2,2)

this will look for the value in A1 on sheet 1
it will look for that value in the range given (A1:C2) on sheet 2 and
return the value in the second column. (e.g 12)


then in C1 put

=VLOOKUP(A1,Sheet2!A1:C2,3)

this will look for the value in A1 on sheet 1
it will look for that value in the range given (A1:C2) on sheet 2 and
return the value in the third column. (e.g room)

You can then copy this down for all the cell on sheet 1.

HTH

Greg.


--
greg7468
------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=378528