Hi all,
i am new to this forum. I have tried functions index and match to fetch a value but could not get success.
my query is :
I have to match two columns and one row to fetch a value, but i am getting error. after using below function.
for example: A50, 3X1.5X10, Mys Max===>569
=INDEX($C$6:$N$26,MATCH(A29&B29,$A$6:$A$26&$B$6:$B$26,0),MATCH(C28,$C$5:$N$5,0))
Please guide me and where i am going wrong.
<tbody>
</tbody>
Regards,
Badmi
i am new to this forum. I have tried functions index and match to fetch a value but could not get success.
my query is :
I have to match two columns and one row to fetch a value, but i am getting error. after using below function.
for example: A50, 3X1.5X10, Mys Max===>569
=INDEX($C$6:$N$26,MATCH(A29&B29,$A$6:$A$26&$B$6:$B$26,0),MATCH(C28,$C$5:$N$5,0))
Please guide me and where i am going wrong.
- | - | FxsMax | FysMax | Fzs Max | Mxs Max | Mys Max | Mzs Max | Fxd Max | Fyd Max | Fzd Max | Mxd Max | Myd Max | Mzd Max |
AA | 1.5X1X6 | 4671 | 3336 | 3336 | 976 | 230 | 230 | 3559 | 6005 | 13345 | 556 | 556 | 556 |
AB | 3X1.5X6 | 4671 | 5516 | 5560 | 1220 | 664 | 664 | 3559 | 6005 | 13345 | 678 | 746 | 691 |
A10 | 3X2X6 | 4671 | 4671 | 4671 | 1220 | 298 | 298 | 3559 | 6005 | 13345 | 678 | 1356 | 691 |
AA | 1.5X1X8 | 4671 | 5382 | 5382 | 976 | 258 | 258 | 3559 | 6005 | 13345 | 488 | 488 | 488 |
--- | 3X1.5X8a | 4671 | 5516 | 5560 | 1220 | 664 | 664 | 3559 | 6005 | 13345 | 597 | 597 | 597 |
A50 | 3X1.5X8 | 12010 | 6005 | 6672 | 1762 | 502 | 502 | 6227 | 6005 | 14457 | 624 | 624 | 624 |
A60 | 3X2X8 | 12010 | 6005 | 6672 | 1762 | 813 | 813 | 6227 | 6005 | 14457 | 895 | 895 | 895 |
A70 | 4X3X8 | 12010 | 6005 | 6672 | 1762 | 475 | 475 | 6227 | 6005 | 14457 | 1627 | 1979 | 935 |
A05 | 2X1X10 | 10409 | 4270 | 4270 | 1722 | 298 | 298 | 6227 | 6005 | 14457 | 895 | 895 | 895 |
A50 | 3X1.5X10 | 12010 | 6005 | 6672 | 1762 | 569 | 569 | 6227 | 6005 | 14457 | 502 | 502 | 502 |
A60 | 3X2X10 | 12010 | 6005 | 6583 | 1762 | 420 | 420 | 6227 | 6005 | 14457 | 759 | 759 | 759 |
A70 | 4X3X10 | 10231 | 6005 | 6672 | 1762 | 420 | 420 | 6227 | 6005 | 14457 | 1627 | 1979 | 935 |
A80 | 6X4X10 | 12010 | 6005 | 6672 | 1762 | 1491 | 1491 | 6227 | 6005 | 14457 | 1627 | 2034 | 935 |
A20 | 3X1.5X13 | 12010 | 6005 | 6672 | 1762 | 908 | 908 | 6227 | 6005 | 14457 | 719 | 719 | 719 |
A30 | 3X2X13 | 8541 | 5471 | 5471 | 1762 | 475 | 475 | 6227 | 6005 | 14457 | 1627 | 1722 | 935 |
A40 | 4X3X13 | 12010 | 6005 | 6672 | 1762 | 542 | 542 | 6227 | 6005 | 14457 | 1627 | 2034 | 935 |
A80 | 6X4X13 | 12010 | 6005 | 6672 | 1762 | 1762 | 1491 | 6227 | 6005 | 14457 | 1627 | 2034 | 935 |
A90 | 8X6X13 | 15569 | 14145 | 8896 | 2034 | 1586 | 1586 | 6672 | 13345 | 15569 | 1695 | 3850 | 3850 |
A100 | 10X8X13 | 15569 | 14145 | 8896 | 2034 | 2712 | 2915 | 6672 | 13345 | 15569 | 1695 | 3850 | 3850 |
A110 | 8X6X15 | 15569 | 14145 | 8896 | 2034 | 2007 | 2007 | 6672 | 13345 | 15569 | 1695 | 3850 | 3850 |
A120 | 10X8X15 | 15569 | 14145 | 8896 | 2034 | 1532 | 1532 | 6672 | 13345 | 15569 | 1695 | 3850 | 3850 |
<tbody>
</tbody>
Regards,
Badmi