Index Match 2nd Match Help

[George__]

I came up with this formula

INDEX('TABLE INPUT'!$B$6:$AAZ$309,MATCH($A7,INDEX('TABLE INPUT'!$C$6:$AAZ$309,0,MATCH($E7,'TABLE INPUT'!$A$3:$AAZ$3,0)-7),0),MATCH($E7,'TABLE INPUT'!$H$3:$AAZ$3,0))

I know i need to use small or large but I tried and get a #value error message

-> 47A

x

x

x

FORMULA -> A-2 (RIGHT)

FORMULA -> A-2 (Should be A-10)

<tbody>
</tbody>

TABLE INPUT

PIN

WIRE

x

x

x

<tbody>
</tbody>

2	47A	x	x	A-10
10	47A	x	x	A-2

<tbody>
</tbody>

Any tips?

Thanks

 

[Special-K99]

"Any tips?"

Yes, explain what you're trying to do in words.

 

[George__]

"Any tips?"

Yes, explain what you're trying to do in words.

Okay

I have individuals tables named A B C D E F G etc

So the formula says (I think)
-- Find the column letter to find the table (black circles)
-- Inside this table find the part # (red circles, column C)

TO section
-- Return the value for what the row the part # is (yellow circles, column B)
--

FROM section
Same thing but if a duplicate part # exists in that table show the 2nd result


EVENTUALLY....
INDEX - MATCH the PART # and ROW ID for both FROM and TO
TO/FROM will match like a ledger


https://imgur.com/a/YYIuMnl