ianripping

=match("a",(indirect(a1)),0)

will do the job.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"ianripping " skrev i en
meddelelse ...
Help!

in A1 I have the entry b1:b20

In A2 I hace the equation =match("a",(indirect("a1")),0)

In b2 I have the entry a

Sure A2's equation should display 2? because a is in row number 2?

Whats wrong?


---
Message posted from http://www.ExcelForum.com/