| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index return value REF#!
This formula returns REF#!
=1*(INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500), MATCH(N7,x!$B$1:$AV$1))) The values are correct in the evaluate formula box, Row:10, Col 2, but then it breaks down. I'e also tried INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500),MATC H(N7,x!$B$1:$AV$1)) I need the formula to return the value in that cell (in this case, B10) What am I doing wrong? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDEX function to return array row. | Excel Worksheet Functions | |||
| help with index to return particular cell value | Excel Discussion (Misc queries) | |||
| return multiple corresponding values using INDEX | Excel Worksheet Functions | |||
| Match/Index return #N/A | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
Threaded Mode
