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
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
Try using INDEX and MATCH for your formula
=INDEX(A1:A1000,MATCH("MS35206-230",C1:C1000,0),0)
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
Thank You!!!!
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks