Vlookup and Now()

Steve · May 23, 2005

is it possible to write a vlookup statement based on the now() function?

JE McGimpsey · May 23, 2005

Yes:

=VLOOKUP(NOW(),A:B,2,TRUE)

Steve · May 25, 2005

That helped a ton. Thank you very much. It turns out I was adding an extra
set of ( ). Thanks again.