M
mjsam
Mike H. This is just not working for me. Here's more specifics
My cube chart is A1:I25 on sheet1
Row Search value is C15 on Sheet2
Column search value is B15 on Sheet2
My formula is on Sheet2
This is what I used and it doesn't give me the correct number.
=INDEX('cube chart'!A1:I25,MATCH(B15,'cube chart'!A2:I2,0),MATCH(C15,'cube
chart'!A1:A25,0))
My cube chart is A1:I25 on sheet1
Row Search value is C15 on Sheet2
Column search value is B15 on Sheet2
My formula is on Sheet2
This is what I used and it doesn't give me the correct number.
=INDEX('cube chart'!A1:I25,MATCH(B15,'cube chart'!A2:I2,0),MATCH(C15,'cube
chart'!A1:A25,0))