View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Norbert[_4_] Norbert[_4_] is offline
external usenet poster
 
Posts: 52
Default Problem with hlookup formula

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!