# Outputting a cells value based on another cell being equal to todays date

1. ## Outputting a cells value based on another cell being equal to todays date

Hi I'm hoping someone can help,

As you can see I have a range of dates in A1:A10
These dates have a corresponding set of values in B1:B10

Where the text is red (call it D5), I would like to output the value in the B column, corresponding to when the date in the A column is todays date

For example if the date were 05/04/2019 the output shows 4345

2. ## Re: Outputting a cells value based on another cell being equal to todays date

in E1

=IF(A1=TODAY(),B1,"")

copy down the column

3. ## Re: Outputting a cells value based on another cell being equal to todays date

Try this formula in E5:

=IFERROR(VLOOKUP(TODAY(),\$A:\$B,2,0),"")

Hope this helps.

Pete

4. ## Re: Outputting a cells value based on another cell being equal to todays date

Thank you both for your help

I still can't quite figure it out and I think I may have written it poorly,

I would only like one output cell
using the TODAY function, this should change daily and then the output should be affected

effectively what I would like It to do is to look at the range of dates in A1:A10, find the one which is equal to todays date, and then print the value from the corresponding cell in B1:B10

I have been advised that INDEX and MATCH may be useful but I am unsure how they would work,

Thanks again,
Harry

5. ## Re: Outputting a cells value based on another cell being equal to todays date

Have you tried any of the suggestions?

Change your data to a date range that covers today's date, enter my formula as specified in column E.
Only one date will appear if you have entered today's date once in that date range.

6. ## Re: Outputting a cells value based on another cell being equal to todays date

Hi,
Yep I did try the suggestions,
However while you're correct that only one date will appear, I do not want a column of numbers etc, I just want the output to be in one specific cell,

7. ## Re: Outputting a cells value based on another cell being equal to todays date

Then use Pete_UK's formula - it works.

8. ## Re: Outputting a cells value based on another cell being equal to todays date

Thank you,

Sorry I misunderstood to begin with,

9. ## Re: Outputting a cells value based on another cell being equal to todays date

Thanks for the rep - glad you got it working in the end.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)