Ask Your Question

Reference cell on different sheet dynamically.. [closed]

asked 2018-10-21 01:26:20 +0200

DocIdaho gravatar image

updated 2020-08-02 03:24:34 +0200

Alex Kemp gravatar image


Sheet 1 cell e4 has value 18

I want then current cell to have the value from cell h18 from sheet 2

Something like (sheet2:h{sheet1:e4})


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-02 03:25:01.014096

1 Answer

Sort by » oldest newest most voted

answered 2018-10-21 02:48:45 +0200

m.a.riosv gravatar image


also there are the functions:



two last are volatile functions, so if you are using a lot of them, using the first is quicker.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-10-21 01:26:20 +0200

Seen: 279 times

Last updated: Oct 21 '18