Returning Multiple Rows of Data (VLOOKUP/INDEX MATCH)

First I apologize if this is a double post, I did search first but didn't see an answer.

I am making up a simple inventory tracker for my warehouse and I have the ability to type in a product number in lets say B2 and it will check my Warehouse page and output 9 columns of information on A5-I5. I want to do this same thing but for when I search for a customer, in this case i might have 5 or more rows of this info, and this is proving to be difficult for me. I think VLOOKUP is out because I'm not searching for the leftmost column and to my understanding you have to for VLOOKUP. I just found out about INDEX MATCH today which seems promising but not sure how to get that to work for this application. VBA was suggested to me but at the moment is a bit beyond my knowledge and was wondering if you guys had any suggestions on new formulas I might be able to try or if i do need VBA, any direction you can give when going that route would be great.

Info about my excel sheet:

Page data is currently stored: "Warehouse"
Cells where Data is: B3:J25 (This will be growing downwards but columns should remain the same)
Customer names are in column C which is 2nd column of table
Page data will be requested: "Part Lookup"
Request & Return cells: Enter Customer name in B2, output results A5:I5 and below

I think thats everything relevant if you need more info let me know!

If anyone could help it would be greatly appreciated! Thanks in advance to you all!
Allan

Thank you guys for such a quick response! I gave it overnight thinking it would take a while but it was only an hour and a half!! Also thank you for the warm welcome I hope to learn lots from everybody here!

I have tried your formula, and it works fine on your book i downloaded but for some reason it halfway works for me. When i type in a customer name it will show all of the parts related to that customer, but the problem i'm having is all columns are showing the part number.

I'll attach a couple screenshots

Capture.JPG
Capture2.JPG

Nevermind I just pasted it wrong, i highlighted the whole row i needed, pasted then ctrl+shift+enter but that made the whole row to have "COLUMN(A:A)" now that i pasted it in the first cell and dragged it over all is well!!

Thank you guys so much for your help! Its nice to find a solution without having to resort to VBA. I do have another question though that probably will need VBA but its unrelated so i'll put up another post for it.

Thanks again!

Glad to help, good luck!

Will do, and jut noticed I can add some rep to you guys as well!

Thanks again