Problem with hlookup formula
On Thursday, 10 December 2020 at 15:41:18 UTC+2, Norbert wrote:
On Thursday, 10 December 2020 at 13:56:46 UTC+2, Claus Busch wrote:
Hi Norbert,
Am Thu, 10 Dec 2020 01:49:52 -0800 (PST) schrieb Norbert:
Hi Claus, I sent you an email from my private account. Up to now, I didn't receive any error. I hope it went through.
the workbook is on the way back to your private account. First I
enlarged the range for "Weekly_Database" to B6:FA505. Then I created the
formula for the customer in cell D8:
=INDEX(WEEKLY_DATABASE,MATCH(B11,INDEX(WEEKLY_DATA BASE,,1),0),MATCH($D$8,INDEX(WEEKLY_DATABASE,1,),0 ))
Regards
Claus B.
--
Windows10
Office 2016
Thanks Claus,
I was actually looking for the formula for cell E11. I sent you a private email.
Please use attached file, as I made a lot of entries in the mean-time.
Thanks!
Hi Claus,
I managed to change the formula to work in E11 and to give me the correct answer.
The formula is this:
=INDEX(WEEKLY_DATABASE,MATCH(B11,INDEX(WEEKLY_DATA BASE,,1),0),MATCH($D$8,INDEX(WEEKLY_DATABASE,1,),0 )+1)
But it only worked when I enlarged the range for "Weekly_Database" to B6:FA505. But why would I have to do that? I don't
understand!
|