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

"JE McGimpsey" wrote:

Yes:

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


In article ,
"Steve" wrote:

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