Match Returns #N/A

  • Thread starter Thread starter rishiyoor
  • Start date Start date
R

rishiyoor

With the following in my sheet...


A B C
1 4
2 5 {=MATCH(5,A2:A2,0)}
3 6 {=MATCH(5,ABS(A2:A2),0)}


B2 returns 1, while B3 returns #N/A. Why?

-Rishi
 
You can't have an array range as an argument to ABS( ) - it must be a
single cell or number.

Pete
 
A B C
1 4
2 5 {=MATCH(5,A2:A2,0)}
3 6 {=MATCH(5,ABS(A2:A2),0)}

B2 returns 1, while B3 returns #N/A. Why?
Click to expand...

Because as written, ABS is not returning an array.

Try one of these:

Array entered:

=MATCH(5,ABS(A1:A10),0)

Normally entered:

=MATCH(5,INDEX(ABS(A1:A10),,1),0)



--
Biff
Microsoft Excel MVP


You can't have an array range as an argument to ABS( ) - it must be a
single cell or number.

Pete
 
Back
Top