Ask Your Question
0

Reference cell on different sheet dynamically..

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

DocIdaho gravatar image

I.e.

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})

Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

m.a.riosv gravatar image

=INDEX(sheet2.h:h;sheet1.e4;0)

also there are the functions:

=INDIRECT("sheet2.h"&sheet1.e4)

=OFFSET(sheet2.h1:sheet1.e4;0)

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 48 times

Last updated: Oct 21 '18