CODEWITHSUNDEEP
excelexcel-formula
Sujith Kp
Sujith Kp

Reputation: 1105

how to get the value of another cell

How can I get the value of a cell in another row ( for e.g. "F" and row() - 1) ? I want to concatenate two letters , for eg. F and 3 and then i need the value in F3.

can anyone help ?

Thanks in advance.

Upvotes: 2

Views: 3266

Answers (1)

brettdj
brettdj

Reputation: 55702

If this formula was in row 4 then =INDIRECT("F"&ROW()-1) would return the value in F3

Upvotes: 4

Related Questions