How to return multiple results based on multiple criteria

Thanks Twifoo.  That is what I had done and I have a solid grasp of what you did.  Using an index within a named range was a brilliant idea.  I would never have thought of that on my own.  Now I need to check if the worksheet formulas work when we load all the locations.  (If needed, I may be able to use some cheater cells with the INDIRECT function.  But I don't think it's going to be a problem.)  We're also chasing exception handling; such as, a user entering the same component twice.  The example I provided was very simple compared to the actual data that will be entered and results that will need to be returned.  But so far, everything is working splendidly.  Thanks again.