xor, I guess I am still a little lost in your formula. I can add tractors to the left column and it picks them up and all is good. I added a part in column 12 and I can't get it to grab that part. I changed the last part of your formula from C11 to C12 thinking that would add the extra column to look in. That didn't work. I maybe need a little more explanation of the formula itself and where it is getting the info.

Matt

I see that you have "tables" made to identify tractors and parts. The tractors automatically expands but the parts don't. I have tried to get the parts table to automatically grow with no luck.


I have figured it out!

Thanks so much for the help!!