Copy cell value in other cell

[salim]

Hi everybody,

I need to copy a value which is in column 2 row 7 to paste it in column 3 row 1. I can with the function " column (2)" copy the value from column 2 but that pastes the first value and i need to paste the value in row 7. Could you help me?

Maybe I have to use rowno() function ? I already tried but not success

Thanks you

[Gysbert_Wassenaar]

Try the below() function with the appropriate offset to get the value from the correct row.