Date refrencing
in [Functions]
|
From: Amin on 19 Apr 2010 06:55 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
From: Eduardo on 19 Apr 2010 08:02 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
From: Ms-Exl-Learner on 19 Apr 2010 08:10 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
From: Amin on 20 Apr 2010 11:08 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
|
Pages: 1 Prev: COUNTIF PROBLEM Next: i dont know if sumif ,,,,, please help |