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

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

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!

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

Hi Norbert,

Am Wed, 9 Dec 2020 04:12:59 -0800 (PST) schrieb Norbert:

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)

try:
=INDEX(8:8,,MATCH(D8,WEEKLY_DATABASE,0))


Regards
Claus B.
--
Windows10
Office 2016

On Wednesday, 9 December 2020 at 14:26:04 UTC+2, Claus Busch wrote:
Hi Norbert,
Am Wed, 9 Dec 2020 04:12:59 -0800 (PST) schrieb Norbert:

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)
try:
=INDEX(8:8,,MATCH(D8,WEEKLY_DATABASE,0))


Regards
Claus B.
--
Windows10
Office 2016
Hi Claus,
nope, unfortunately it doesn't work. It brings back N/A

I might have to say that my range WEEKLY_DATABASE is on sheet: "weekly"
The formula, I need on sheet: "calculations", cell E11

When I trace Precendents of your formula (which I don't understand at all!!!) I get markers on sheet: "calculations"
(the entire row 8 is framed by a blue frame and there is an arrow from A8 and D8 to my cell with the formula (E11)
and the one for my range: WEEKLY_DATABASE on sheet: "weekly"