Answer the question
In order to leave comments, you need to log in
Is there a function where, instead of specifying the address D444, it was possible to specify that the link is on top of the current cell?
There is a code
=REGEXEXTRACT( ИНДЕКС(IMPORTHTML(D994;"table";0);2;1);"[\s\S]*\d+\s*(?:-\s*)?(\S+)")
Answer the question
In order to leave comments, you need to log in
Cell above:
ДВССЫЛ("R[-1]C";0)
Cell right:
ДВССЫЛ("RC[1]";0)
Cell left:
ДВССЫЛ("RC[-1]";0)
Cell below:
ДВССЫЛ("R[1]C";0)
The logic is: R = row = row; C = column = column
If the number is without
brackets
, it is an absolute reference same row/column
, etc.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question