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"