MATCH function (2003 - 2007)
 

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.

MATCH function (2003 - 2007)
 

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.

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.