Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

=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.