Thread: integrating row number in a formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Grymjack Grymjack is offline
external usenet poster
  
Posts: 13
Default integrating row number in a formula
works perfectly...thanks for the info!!

Jim Thomlinson wrote:
I think you want indirect

="S_"& indirect("A" & row()) &"_"&TEXT(C3,"dd")

Reply With QuoteReply With Quote