call up value in cell range by today's date

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,

Hi
if A1:A31 contains dates from this month, try this:

=OFFSET(A1,MATCH(TODAY(),A1:A31,0)-1,1)

if A1:A31 contains dates from the corresponding month last year, try this:

=OFFSET(A1,MATCH(DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),A1:A31,0)-1,1)

excellent! it works .... thanks very much

Originally Posted by AliGW

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Done... thanks