Excel 2007 - Combine vlookup with today's date/time 1

[BxWill]

Have the following if statement that populates a cell (B2) within a Excel 2007 worksheet with a value if column A is not blank.

The formula currently returns the value of "Now()" as a serial value.

My objective is to append the result of the vlookup with today's date and time - the date and time that the vlookup was performed.

=IF(A2="","",IF(ISERROR(VLOOKUP(A2,AcctNbrsOnWksht,1,FALSE)),"Yes","AlreadyOnWksht" & " as of " &NOW()))

What modifications to the IF statement is needed to accomplish objective?

Will continue to troubleshoot but appreciate any insight.

 

[Lilliabeth]

=IF(A2="","",IF(ISERROR(VLOOKUP(A2,AcctNbrsOnWksht,1,FALSE)),"Yes","AlreadyOnWksht" & " as of " &TEXT(NOW(),"mm/dd/yyy")))

--Lilliabeth