MATCH function not working

[shriil]

Hi,

I have the following columns, A, B & C where C column data is = A1&B1, A2&B2,....

When I am trying to find the Row no. by using the formula

MATCH($C$2,$A$1:$C$4,0), I am getting a #N/A error.

A B C

- - < 0.65 0.9 - 0.95 - - < 0.650.9 - 0.95
0.65 - 0.7 0.95 - 1 0.65 - 0.70.95 - 1
0.7 - 0.75 1 - 1.02 0.7 - 0.751 - 1.02
0.75 > - - 1.02 - 1.04 0.75 > - -1.02 - 1.04


Where am I committing the mistake. Pls Help

San

 

[Claus Busch]

Hi,

Am Mon, 19 Aug 2013 11:31:30 -0700 (PDT) schrieb shriil:

MATCH($C$2,$A$1:$C$4,0), I am getting a #N/A error.

A B C

- - < 0.65 0.9 - 0.95 - - < 0.650.9 - 0.95
0.65 - 0.7 0.95 - 1 0.65 - 0.70.95 - 1
0.7 - 0.75 1 - 1.02 0.7 - 0.751 - 1.02
0.75 > - - 1.02 - 1.04 0.75 > - -1.02 - 1.04

try:
=MATCH(C2,$C$1:$C$4,0)


Regards
Claus B.

 

[shriil]

Hi,



I have the following columns, A, B & C where C column data is = A1&B1, A2&B2,....



When I am trying to find the Row no. by using the formula



MATCH($C$2,$A$1:$C$4,0), I am getting a #N/A error.



A B C



- - < 0.65 0.9 - 0.95 - - < 0.650.9 - 0.95

0.65 - 0.7 0.95 - 1 0.65 - 0.70.95 - 1

0.7 - 0.75 1 - 1.02 0.7 - 0.751 - 1.02

0.75 > - - 1.02 - 1.04 0.75 > - -1.02 - 1.04





Where am I committing the mistake. Pls Help



San

Thanks Claus. That worked. Could you please tell me why my method did not work