On Jun 27, 5:10 pm, Billy Liddel
wrote:
I looked at Barbara's sugestion about dates being entered as text and added a
space before a couple of dates. this gave the zero answer as before with the
array function. If this is the case you can convert these with a macro.
select the dates and run this but you will then have to re-enter your formula.

Sub T()
For Each c In Selection
c.Value = Trim(c)
Next
End Sub

However, you can ignore these errors with the lookup function that will
return the text in say, D1 Then use something like:
=IF(TRIM(D1)TODAY()-10,"Activate","OK") to highlight what action to make.

Hope this helps

Peter

"Billy Liddel" wrote:
Shrini

I could not reproduce your error. If I went outside the range the formula
returned
01/01/1900 or 0 formatted to general. with the test data Utilisation DAte
is in column B and test Equipment was in A, so using a name of data for both
columns I could repeat your result with the following formula

=VLOOKUP(A1,Data,2,0)

I know this does not answer your question I'll look forward to other replies.

Peter

Dear all,

I could solve the problem by avoiding the cell result to #N/A since
the Vlookup formula was giving #N/A error due to blank lookup cell.

But thanks for your inputs as it made me rethink on the same.

regards,

Shriniwas.