ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Part Number Lookup (https://www.excelbanter.com/excel-worksheet-functions/34677-part-number-lookup.html)

Marshall2

Part Number Lookup
 

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


Anne Troy

Hi, Marshall. I have a tutorial that shows you how:
http://www.officearticles.com/tutori...excel.htm#boss

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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




Bob Phillips

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





All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com