software

I want to find the information in column 'A' after finding the
referenced cell i asked for.

My search is for MS35206-230 but I want Column A returned

Example

Col A Col B Col C
.05 Red MS35206-230--
MrSales
------------------------------------------------------------------------
MrSales's Profile: www.excelforum.com/member.php...oamp;userid=32572
View this thread: www.excelforum.com/showthread...hreadid=523698
Try using INDEX and MATCH for your formula

=INDEX(A1:A1000,MATCH(quot;MS35206-230quot;,C1:C1000,0),0)--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=523698Use the MATCH function to find the row and then put inside the INDEX
function

--
Don Guillett
SalesAid Software

quot;MrSalesquot; gt; wrote in
message ...
gt;
gt; I want to find the information in column 'A' after finding the
gt; referenced cell i asked for.
gt;
gt; My search is for MS35206-230 but I want Column A returned
gt;
gt; Example
gt;
gt; Col A Col B Col C
gt; 05 Red MS35206-230
gt;
gt;
gt; --
gt; MrSales
gt; ------------------------------------------------------------------------
gt; MrSales's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32572
gt; View this thread: www.excelforum.com/showthread...hreadid=523698
gt;

A1 A2

Col 1 Col2 Col3
Col 4
MS21044D9 AN365D918 AN365D918A MS20365D918
MS21044N02F22NM-256F22NM-02
MS21044N04F22NM-440F22NM-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 A2.

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=523698
Thank You!!!!--
MrSales
------------------------------------------------------------------------
MrSales's Profile: www.excelforum.com/member.php...oamp;userid=32572
View this thread: www.excelforum.com/showthread...hreadid=523698