Match function

[learninman]

Hi,
I am having a Problem with the match function.
I am trying to find the row number of the column that contains the value that I am looking for.
I have column A with values that are alpha numeric like <TABLE style="WIDTH: 65pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=86><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 65pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=86>06251AWP1 </TD></TR></TBODY></TABLE>
and I have simmillar values in column C that match values in column A. All values have the same number of digits
I tried this:
=MATCH(C1,A1:A200)
but I get the wrong result. It gives me a result that I think has no correlation to the correct answer which should be row 107
Is there a limit to how many digits the value you are looking for in a Match function can have?

 

[VoG]

Try

=MATCH(C1,A1:A200,0)

 

[learninman]

that works, thank you very much!