Formula matching multiple variables to bring back one quantity value

[lsdientz]

Need help with creating a formula. I have tried several different ways to include ifs/xlookups/index-matches but I think I might be in over my head. I am needing to update my Kit Summary sheet with the new numbers in the Order sheet. I have to match the Kit Names in column A and the Kit Numbers in column B of the Kit Summary with the Kit Names in Column A and Kit Numbers in row 1 of the Order Sheet. On top of that, I have to also match the Ordering years on the Kit Summary sheet (row 1) with the ordering years that correspond on the Order Sheet in the first column. I am having a huge issue since one spreadsheet is setup more vertically and the other spreadsheet is setup more horizontally. Any help is always appreciated. Thank you.

Kit Summary:


Order Sheet:

 

[Jeffrey Mahoney]

I want to help, but I don't want to recreate those tables. Can you post using XL2BB?

 

[lsdientz]

I'm on a company laptop now but when I get home I download the add-in to my personal computer and post from that. Thank you.

 

[lsdientz]

I have tried to download and use that add in. Unfortunately I'm afraid the excel version on my macbook air is too outdated. It couldn't read some of the content and the add in doesn't work. But thank you for your initial offer to assist. I will keep working on it.