Hi
What mistake I am doing to get figure 150 in cell G2? Please help
formula I am applying
What mistake I am doing to get figure 150 in cell G2? Please help
formula I am applying
=INDEX($B$2:$D$5,MATCH(1,($A$2:$A$5=$F2)),MATCH(G1,$B$1:$D$1,0)) |
Size | Alpha Kraft | Box Board | Delta | Alpha Kraft | ||
20 | 150 | 0 | 0 | 20 | #N/A | |
21 | 0 | 5 | 0 | |||
22 | 0 | 0 | 15 | |||
23 | 0 | 0 | 0 |