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

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.
 
S

Sheeloo

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect formula errors if file is closed 0
Using SUM(INDIRECT()) 2
Copy addition formula of non-consecutive horizontal cells 2
Depedent Dropdown and INDIRECT($P$8) with a twist 4
Converting from Decimal to Base-36 in Excel Formula 3
Repeating a row other than the 1st row as the header row in a table from next page 1
Adding another if statement to an index formula 0
HELP: IF Statement between Dates for Reverse Index failing 0

Top