Please post your formula for giving a better solution. Anyway have a look in
the below example:

Assume that I am comparing the Summary sheet A2 cell value with Inventory
From the Column A to C and I would like to get the result of C column if the
Summary sheet A2 cell value match with Inventory A Column data.

When the Summary sheet A2 cell is formatted as Date and if I use the below
formula
=VLOOKUP(A2,Inventory!A:C,3,FALSE)
Then I will get the error which is mentioned by you.

To come out of this issue if you construct your formula like the below then
you wont get any values in A2 cell and it will be shown as Blank.

=IF(VLOOKUP(A2,Inventory!A:C,3,FALSE)=0,"",VLOOKUP (A2,Inventory!A:C,3,FALSE))

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Amin" wrote:

hi i have two sheets one is inventory the other is summary with the same
style and clumn headings.
now i want the date of the summary sheet to record the dates put in the
inventory column but when i use the formula i get 1900 year, i suppose becos
i yet dont have dates but is there a better way of doing this thing. thanks