Use value from one cell based on the date in adjacent cell

[doublej41]

Hi All,

I have what I imagine is a very basic query here.

In column A I have the date and in column J I have a list of numbers, starting at 1 and going up in increments of 1. What I would like to do in cell K2 is take the value from column J that relates to today's date and subtract the value that is calculated cell K1.

So each day the value from column J that is used in the calculation in cell K2 should increase by 1.

This is as far as I have made it, from this all I get is 'False':

=IF($B$3:$B$190=TODAY();$J$3:$J$190-Sheet2!B6)

I hope this makes sense.

Thanks in advance for any help.

Jonathan

 

[SteveO59L]

Have a look at VLookup()

 

[doublej41]

Worked a treat.

Thanks for the speedy reply!