Date search

[MarkBeck54]

Hi

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

[#2 · Accepted solution]

@MarkBeck54 Perhaps the picture below can help.

[#3]

@MarkBeck54 

=VLOOKUP(TODAY(),$D$3:$E$20,2,0)

Maybe with this formula as shown in the attached file.

[#4]

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

[#5]

Thank you works a treat