Thread: use the result of match function as a part of row address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kang kang is offline
external usenet poster
  
Posts: 38
Default use the result of match function as a part of row address
I want to use the result of match function as a part of row address.
that is;
if "=MATCH(B7,$B$1:$B$7,0)" gives 3 then $a$(MATCH(B7,$B$1:$B$7,0))
things like that.

is it possible?
Reply With QuoteReply With Quote