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

Try this formula in E5:

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

Hope this helps.

Pete

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

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,

Thank you,

Sorry I misunderstood to begin with,
Your help is appreciated

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

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete