MATCH function with text - confused

  • Thread starter Thread starter genzu
  • Start date Start date
G

genzu

Hello All,

I thought that I understood the MATCH function, but
I can't seem to get it to work on the simplist of
cases. I have the following contents in colum A1:A25,

ED
ATM -
EW
ED
C1131
EW
ED
DEP
EW
EW
ED
EW
ED
C1133
EW
ED
ED
DEP
C1134
EW
OTH
C1130
EW
ED
ED

I'm only trying to use MATCH to determine what
row "C1130" (for example) appers in, i.e.: 22.

But when I use the match function:
=MATCH("C1130",A1:A25)
I get "N/A"

All of the C**** values are unique in my full
array, but it can't seem to locate the row
properly.

Thanks in advance for any imput on this one!

Peace.

Daryl "Genzu Blades" Genz
Owner, Freedom Footbags
http://www.freedomfootbags.co
 
Aladin,

Thanks very much for your help. I knew it wasn't that
complicated, I was just getting funky results, and
now I know why. :)

Peace.


Genz
 
Back
Top