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