I need help with a formula

[MrSales]

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

[kraljb]

Try using INDEX and MATCH for your formula

=INDEX(A1:A1000,MATCH("MS35206-230",C1:C1000,0),0)

[Don Guillett]

Use the MATCH function to find the row and then put inside the INDEX
function

--
Don Guillett
SalesAid Software
[email protected]
"MrSales" <[email protected]> wrote in
message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=32572
> View this thread: http://www.excelforum.com/showthread...hreadid=523698
>

[MrSales]

A1 A2

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 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]

Thank You!!!!