ExcelBanter - Match & Indirect

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Match & Indirect (https://www.excelbanter.com/excel-programming/296159-match-indirect.html)

ianripping[_56_]

Match & Indirect

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

Leo Heuser[_3_]

Match & Indirect

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/

All times are GMT +1. The time now is 12:27 PM.