Problem with hlookup formula
On Wednesday, 9 December 2020 at 13:36:12 UTC+2, Adrian Caspersz wrote:
On 09/12/2020 11:27, Norbert wrote:
Hi,
how can I get the value of the neighbouring cell of the cell which is found by
a hlookup formula returned.
E.g: my hlookup formula finds the cell C372 but I want the value of D372
You need the OFFSET function
--
Adrian C
Thanks Adrian! Never used Offset before, but it makes sense. Cool!
|