Hi !

Would be great, if you could help me for the following:

PROBLEM A

Let's say cell range A1 - A31 contains the dates 1 July 2019 - 31 July 2019

And cell range B1 - B31 contains different numeric values for each date, so for example 15 July 2019 (A15) has the number 22 (B15) next to it.

I am looking for a solution for a daily report to automatically call up the data as per its corresponding date from another excel workbook.

--> If today's date is 15 July 2019, call up the corresponding value from range B1 - B31 (the answer is "B15" or "22") .

PROBLEM B

Cell range A1 - A31 contains the dates 1 July 2018 - 31 July 2018

And cell range B1 - B31 contains different numeric values for each date, so for example 12 July 2018 (A12) has the number 14 (B12) next to it.

I am looking for a solution :

If today's date is 12 July 2019, call up the corresponding value from last year 12 July 2018, cell range B1 - B31 (the answer is "B12" or "14")


Thanks a lot, have a great day

Best Regards,