Date search

Occasional Contributor


I know this is probably simple to solve but cant get the result I need without errors

I have a column of dates:

and a column of pay amounts:

In a seperate cell I have the today() function

I am trying to compare todays date with the date list and extract the pay amount into a seperate cell

all ideas are welcome

4 Replies
best response confirmed by Sergei Baklan (MVP)

@MarkBeck54 Perhaps the picture below can help.

Screenshot 2022-01-13 at 18.17.49.png




Maybe with this formula as shown in the attached file.


Hi I tried this but still getting #N/A I have tried this with data on seperate sheet still the same error
Thank you works a treat