Problem with hlookup formula
On Wednesday, 9 December 2020 at 13:50:26 UTC+2, Norbert wrote:
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!
Thats my hlookup formula:
=(HLOOKUP(D8,WEEKLY_DATABASE,376,FALSE) it works! but I need the value of the next column
and that's what I tried, but doesn't work:
=offset(HLOOKUP(D8,WEEKLY_DATABASE,376,FALSE),0,1)
error message: There is a problem with this formula. Not trying to type a formula? .......
|