data or lookup????

[pamela16]

Hi

I have attached a spreadsheet. I am not entirely sure what formula to use. What I'd like to achieve is:

When I put the Machine number on F1 (Parts worksheet) it will pull all the parts from 'Customer Data' Columns Q-AM and its quantities.

Thank you in advance and will appreciate your help.

[Glenn Kennedy]

maybe this:

=IFERROR("M-"&INDEX('Customer Data'!$3:$3,,AGGREGATE(15,6,COLUMN($Q$4:$AM$117)/(INDEX('Customer Data'!$Q$4:$AM$117,MATCH(Parts!$F$1,'Customer Data'!$A$4:$A$117,0),)>0),ROWS($1:1))),"")

I have included the M- prefix that is NOT present in the Customer Data sheet.

[Bo_Ry]

Please try at Part

A4 with Ctrl+Shift+Enter

Please Login or Register  to view this content.

C4 with Ctrl+Shift+Enter

Please Login or Register  to view this content.

Copy both down

[pamela16]

Thank you so much all.. Made it all easier.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.