software

A1 B1

Col 1 Col2 Col3 Col 4
MS21044D9 AN365D918 AN365D918A MS20365D918
MS21044N02 F22NM-256 F22NM-02
MS21044N04 F22NM-440 F22NM-40 MS20365-440A

I want to be able to type any part number in A1 and have it return the
corresponding information in column a of that line in B1.

I have a database of 25 columns and 50,000 lines.

I understand VLOOKUP and HLOOKUP but they don't work for the obvious
reasons.

Thank You--
MrSales
------------------------------------------------------------------------
MrSales's Profile: www.excelforum.com/member.php...oamp;userid=32572
View this thread: www.excelforum.com/showthread...hreadid=523796What obvious reason would that be?

www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;MrSalesquot; gt; wrote in message
...
gt;
gt; A1 B1
gt;
gt; Col 1 Col2 Col3 Col 4
gt; MS21044D9 AN365D918 AN365D918A MS20365D918
gt; MS21044N02 F22NM-256 F22NM-02
gt; MS21044N04 F22NM-440 F22NM-40 MS20365-440A
gt;
gt; I want to be able to type any part number in A1 and have it return the
gt; corresponding information in column a of that line in B1.
gt;
gt; I have a database of 25 columns and 50,000 lines.
gt;
gt; I understand VLOOKUP and HLOOKUP but they don't work for the obvious
gt; reasons.
gt;
gt; Thank You
gt;
gt;
gt; --
gt; MrSales
gt; ------------------------------------------------------------------------
gt; MrSales's Profile: www.excelforum.com/member.php...oamp;userid=32572
gt; View this thread: www.excelforum.com/showthread...hreadid=523796
gt;