Help with some combination of IF, Match functions

Greetings,

I know the answer to this will probably be simple. But I hope you all wont mind taking the time to help. I have two tables. The first contains 8 columns of numbers..in somewhat sequential order. There are "chunks" of sequential numbers missing at random points. Here is a portion of it. Capture.JPG

The other is a table with more detailed information. Capture2.JPG

I want to write a formula in B2 of the "sheet 2" that will see if A1 is in one of the 4 columns of "Inventory 2015" or one of the 4 columns of "Inventory 2016" in "sheet 1" that would than return "2015" or "2016" depending on which one of the 2 larger columns that number is in.

Hope this is clear. Thanks for nay help in advance.

I would rather not because some of the data is sensitive/personal information. That's why I posted screenshots of the relevant and harmless data.

Nobody is going to type in your data so remove/disguise any sensitive data.

I am not sure I am willing to go through the hassle of removing all the sensitve data. Thanks anyways!

How long would it take to cut & paste the 15 rows in your images to the 2 sheets? We don't need more data than this providing it illustrates what is required.

Any columns not required can be left blank

In B2

=IF(SUMPRODUCT((Sheet2!$A$3:$H$2538=Sheet1!$A2)*(COLUMN($A$1:$H$1)))<=4,2015,2016)

in C2

=INDEX(Sheet2!$A$2:$H$2,SUMPRODUCT((Sheet2!$A$3:$H$2538=Sheet1!$A2)*(COLUMN($A$1:$H$1))))