Need formula like "=INDIRECT("X"&$K$(ROW())"

  • Thread starter Thread starter chaiyot
  • Start date Start date
C

chaiyot

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.
 
="X" & INDIRECT("$K$"&ROW())

If you enter this in row 3 then this will give you
= "XY"
if K3 contains Y
 
Back
Top