| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect function syntax
I am trying to use the following formula:
=MATCH(G1,INDIRECT("'Sheet3'!"&"D"&MATCH(B4,Sheet3 !$A$2:$A $21647,0)):INDIRECT("D"&MATCH(B4,Sheet3!$A$2:$A$21 647,1)),-1) but keep getting the #VALUE!. When I do the formula auditing, it works until he =MATCH(125,Sheet3!$D$21323:$D$21645,-1) then: =MATCH(125,#VALUE,-1) Am I doing something wrong? Thanks for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect formula syntax | Excel Worksheet Functions | |||
| Syntax on Indirect() | Excel Discussion (Misc queries) | |||
| Indirect and Sumif Syntax Problems | Excel Discussion (Misc queries) | |||
| Syntax for IF function | New Users to Excel | |||
| INDIRECT syntax? | Excel Worksheet Functions | |||
Threaded Mode
