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
<tbody>
</tbody>
TABLE INPUT
<tbody>
</tbody>
<tbody>
</tbody>
Any tips?
Thanks
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