Could you possibly upload a copy of the real application (with an indication where you want the result to appear)?

Here is basically what I am looking for.

Matt

Attached Files

Iventory mock up test.xlsx (12.8 KB, 9 views)

And here is my proposal.

Attached Files

Iventory_mock_up_2.xlsx (15.2 KB, 10 views)

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!!