ExcelBanter - Vlookup and Now()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup and Now() (https://www.excelbanter.com/excel-worksheet-functions/27341-vlookup-now.html)

Steve

Vlookup and Now()

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

JE McGimpsey

Yes:

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

In article ,
"Steve" wrote:

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

Steve

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?

All times are GMT +1. The time now is 08:11 PM.