Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross Reference Formula | Excel Worksheet Functions | |||
Cross Reference Formula | Excel Worksheet Functions | |||
Cross Reference Formula | Excel Worksheet Functions | |||
Cross reference | Excel Discussion (Misc queries) | |||
Cross reference | Excel Worksheet Functions |