I need help with a formula

  • Thread starter Thread starter MrSales
  • Start date Start date
M

MrSales

A1 A2

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


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 A2.

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
 
your data makes absolutely no sense to me,sorry.The actual part number is in
which column?What information do you want displayed in A2?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need help with a formula 1
I need help with a formula 4
Need formula help! 1
Need help with a formula with zero 5
Need help with a function 1
... I need some help with a formula ... 3
Need help with Excel formula!! 5
need help with a vlookup but returning a particular match? 4

Back
Top