Hi,

Thanks for your help but what if my data would be like below:

A
..
..
15 aaa
16 bbb
17 ccc
18 ddd

so if i put formula like: =MATCH("ccc",A15:A18) the resuilt comes up 3 but
if i put the formula like: =MATCH("ccc",A1:A18) the result comes up 17.
Please advice.

Thnaks

--
Farhad Hodjat


"Gary''s Student" wrote:

=MATCH("ccc",A1:A10)

--
Gary''s Student - gsnu200758