MATCH function (2003 -> 2007)

R

RL

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.
 
S

Sheeloo

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
 
R

RL

Thanks! It works...

Sheeloo said:
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 said:
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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search cell value in same column 3
VLOOKUP returning #N/A ?? 3
enter value if 2 criteria are met 5
countifs Function not giving desired result with date criteria 2
Excel 2003 with Reference error cause me a headache 0
IF Statement Problem 4
if(isna(match formula 8
If function to match cols and return value of another col 1

Top