| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH function (2003 - 2007)
Thanks! It works...
"Sheeloo" wrote: Excel 2003 also returns #N/A with =MATCH(A2, B2,0) with B having the value A2:A25 (without quotes) However =MATCH(A2, INDIRECT(B2),0) works ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "RL" wrote: Why is it foruma #2 below returns "#N/A" in Excel 2007? 1. =MATCH(A2, A2:A25,0) [Excel 2007 returns the value of A2, assuming A2 contains one of the values found in A2:A25] 2. =MATCH (A2, B2, 0), where B2="A2:A25" [Excel 2007 returns "#N/A."] RL PS. In Excel 2003, both formula returns the same correct A2 value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
| Function dosn't work in Excel 2007 but did in 2003 | Excel Worksheet Functions | |||
| Sorting function in Excel 2003 lost in the 2007 version | Excel Worksheet Functions | |||
| Snapshot function, 2003 to 2007 | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Threaded Mode
