M
MrSales
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 th
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 obviou
reasons.
Thank Yo
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 th
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 obviou
reasons.
Thank Yo