CODEWITHSUNDEEP
excelexcel-formula
Athos
Athos

Reputation: 43

Change cell line based on another cell number

There is a way where I can do something like that? : =D{K2} Where D is column and {K2} defines the line based on K2 value Ex : K2=5 -> =D{K2} -> =D5

Upvotes: 0

Views: 28

Answers (1)

P.b
P.b

Reputation: 11493

=INDIRECT("D"&K2) With the given example this will get you a reference to the value of cell D5.

Upvotes: 1

Related Questions