help please!

[nathantmoore89]

I have a sheet1 that has a list of items for kit 1 a list of items for kit 2 and list of items for kit 3, i have an ongoing project that it needs to be pulled to sheet 2 depending on orders i may have kit 2 one week and kit 4 another week, I have the kit name pulling automatically but i need a formula that will see kit 1 on the order tab and pull all items that belong to kit 1 i find vlookup only pulls the first in the list. PLEASE HELP

 

[Tivakaran]

Can you post the screenshot or provide the file please?

 

[nathantmoore89]

 

[nathantmoore89]

ON THE BUILDING SHEET I NEED IT TO SEARCH THE ORDERS AND PULL ALL MATCHING PART NUMBERS.

 

[Tivakaran]

Wow.. its really confusing for me... why dont you use pivot table instead? So you can just columnised by kit#