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

Hi,
sounds like a format problem, right click on the mouse, cell format, date,
choose the desired format

"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

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

Hi there sorry for the delay but thanks for the assistance, so far i have not
used your strategy yet but theble i trouble i have looks like this. two
sheet one is summary the other is inventory i want the summary to record the
days in the inventory so i did this: =Inventory!C4 and got this: 00 January
1900 hope t
his will help you get it for me

"Ms-Exl-Learner" wrote:

> 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