Need help with a formula that will search my spreadsheet and display the results elsewhere

Hello all,

I have been racking my brain pretty hard trying to figure this one out - I'm definitely an excel rookie.

Basically what I have is a spreadsheet with three columns that the business I work for uses to track our tool inventory. The three columns are: Tool Description, Serial #, and job number. When a tool is checked out to a job site, the appropriate job # is placed next to each tool.

What I would like to do is have a separate sheet where I can type in the job # and have it populate a list of all tools currently assigned to that particular job.

I appreciate any advice you all can give me!

Thank you,
Chris

Unbelievably fast! Can't thank you enough Jeff!

Another quick question here -

Would it be difficult to populate sheet5 with both the item description and serial #?

Also, I tweaked the code a bit as the tool inventory contains roughly 500 items. I'm having a hard time trying to figure out why only a portion of the tools assigned to a particular job are populating on sheet5. If job 123 has 20 tools assigned, only the first 7 are showing up when I search that particular job #.

=IFERROR(INDEX(Sheet4!$A$2:$A$500,
SMALL(IF(Sheet4!$C$2:$C$500=$A$1,ROW(Sheet4!$C$2:$C$500)-1),ROW(A1))),"")

Again, all help is greatly appreciated

Tools-Sample.xlsx

No problem at all, here it is!

That is correct - I just plugged in a random number. Each serial number will be unique

That is perfect - you are the man Jeff! You have saved me from many headaches!