="X" & INDIRECT("$K$"&ROW())

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


"chaiyot" wrote:

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.