View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ianripping[_56_] ianripping[_56_] is offline
external usenet poster
 
Posts: 1
Default 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