Match Returns #N/A

[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

 

[Pete_UK]

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

Pete

 

[T. Valko]

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?

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