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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need formula like "=INDIRECT("X"&$K$(ROW())" (https://www.excelbanter.com/excel-worksheet-functions/208987-need-formula-like-%3Dindirect-x-%24k%24-row.html)

chaiyot

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

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.

Peo Sjoblom[_2_]

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.

Sheeloo[_3_]

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

="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.

All times are GMT +1. The time now is 07:15 AM.