ExcelBanter - Cross Reference Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cross Reference Formula (https://www.excelbanter.com/excel-worksheet-functions/215866-cross-reference-formula.html)

mjsam

Cross Reference Formula

Mike H
This is driving me crazy,
my cube chart is A1:i25 on cube chart sheet
my row reference is C15 on workup sheet
my column reference is B15 on workup sheet

My formula on the workup sheet is:
=INDEX('cube chart'!A1:I25,MATCH(C15,'cube chart'!A3:A25,0),MATCH(B15,'cube
chart'!B2:I2,0))

And it's not giving me the correct cross reference. what's wrong with my
formula?

JNW

Cross Reference Formula

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

"mjsam" wrote:

Mike H
This is driving me crazy,
my cube chart is A1:i25 on cube chart sheet
my row reference is C15 on workup sheet
my column reference is B15 on workup sheet

My formula on the workup sheet is:
=INDEX('cube chart'!A1:I25,MATCH(C15,'cube chart'!A3:A25,0),MATCH(B15,'cube
chart'!B2:I2,0))

And it's not giving me the correct cross reference. what's wrong with my
formula?

All times are GMT +1. The time now is 02:00 AM.