Yes I can get this array to work. The problem is that it only works for the single row that it is set up for. It is in a small table that shows available parts for a specific piece of equipment. I would like to add the lookup (or match) to find the row the equpment is in, then tell me the parts that are available in that row. Right now I don't have the row tied to the piece of eqipment

I will try to post what I have. We are not set in stone on this and if there is an easier way to set up the initial table I am all ears. We are just starting to track our inventory and I thought this would help the guys.

Matt