I upload a new version because I had forgotten that (in the previous file) I had converted your table to a range without setting it back again.

In the present file I have also put a few comments which might be of some help.

Please disregard my first uploaded file.

Attached Files

Inventory_test_sheet_2.xlsx (15.1 KB, 9 views)

xor, this is exactly what I needed. Still not sure I understand everything you did there but I should be able to figure it out with a little more looking. Like I said, I have really only been working in excel for about 2 weeks now and it is all self taught.

I will put this to work on a larger sheet that involves our real application. One question I have is can I use these forumulas on a separate sheet within the same workbook? My goal is that the employees can have a sheet that looks up parts(and gives location and quantity), or they can look up the piece of equipment and find the parts we have on hand for it.

Thanks again, Matt