Cross Reference Formula
 

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))

Cross Reference Formula
 

Hi,

Don't break up threads, when you do no one else can answer your question
because they don't know where you posted it, when you posted it or what title
you gave it, and we don't have the time to search for random posts.

If Mike never looks at this post you may never get an answer.

What exactly is wrong with

=INDEX('cube chart'!A1:I25,MATCH(B15,'cube chart'!A2:I2,0),MATCH(C15,'cube
chart'!A1:A25,0))

My guess

=INDEX('cube chart'!A1:I25,MATCH(B15,'cube chart'!B1:I1,0),MATCH(C15,'cube
chart'!A2:A25,0))
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mjsam" wrote:

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))