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


[TABLE="width: 556"]
<tbody>[TR]
[TD]-> 47A[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]FORMULA -> A-2 (RIGHT)[/TD]
[TD][/TD]
[TD]FORMULA -> A-2 (Should be A-10)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

TABLE INPUT
[TABLE="width: 568"]
<tbody>[TR]
[TD="class: xl66, width: 83"]PIN[/TD]
[TD="class: xl67, width: 138"]WIRE[/TD]
[TD="class: xl67, width: 86"]x[/TD]
[TD="class: xl67, width: 127"]x[/TD]
[TD="class: xl67, width: 134"]x[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 568"]
<tbody>[TR]
[TD]2[/TD]
[TD]47A[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]A-10[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]47A[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]A-2[/TD]
[/TR]
</tbody>[/TABLE]

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