Thread: Need formula like "=INDIRECT("X"&$K$(ROW())"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default Need formula like "=INDIRECT("X"&$K$(ROW())"
=INDIRECT("'X'!K"&ROW())

--


Regards,


Peo Sjoblom

"chaiyot" wrote in message
...
Hi there,
I'ld like to use the formula like "=INDIRECT("X"&$K$(ROW())". Need row
number to use in this function. HELP ME PLEASE

Thank in advance.
Regards,
Chaiyot.


Reply With QuoteReply With Quote