Look at VLOOKUP in Excel help.

--
HTH

Bob Phillips

"Marshall2" wrote
in message ...

undefinedHELP!
I need to write a formula which will lookup a part number from a sheet
and return the values in the adjoining horizontal cells to the new
sheet. Is this possible?


--
Marshall2
------------------------------------------------------------------------
Marshall2's Profile:
http://www.excelforum.com/member.php...fo&userid=2505
View this thread: http://www.excelforum.com/showthread...hreadid=386034