Match not working?

[spacely]

I don't know how to post a sample file... but I can describe:

I am just doing a match, and it's not working. I want the row number in which the string appears:

In A1
4001,4002,4003,8015,8019,4007,4009,8045,8047,8053,8055,8072,8074,2324,2330,8078,8087,8024,8089,8091,4119,4120,4048,4050,4054,4056,4058,4060,4062,4064,4066,4068,4082,4084,4101,4102


In A2
4004,4005,4008,4013,8046,8048,8054,8056,8073,8075,2325,2329,8079,4035,8084,8085,8086,8088,4047,4049,4053,4055,4057,4059,4061,4063,4065,4067,4081,4083,4099,4100


Match("8084",A1:A2.0) should return a 2.

Is it read as 2 big strings?

Thanks!

 

[AlphaFrog]

Surround it with wildcards

=MATCH("*8084*",A1:A2,0)

 

[spacely]

Perfect. Thank you.

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,FIND(",8084,",","&A1:A2&","),ROW(A1:A2)-ROW(A1)+1)

would skip numbers like 80841, 08084, or 180845.