SOLVED

Date search

Occasional Contributor

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

4 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@MarkBeck54 Perhaps the picture below can help.

Screenshot 2022-01-13 at 18.17.49.png

@MarkBeck54 

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

 

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