Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
I have an out of stock list (updated twice a week) showing the ETA when an
item is due back in stock. The out of stock list is in english and I need to create one for my french agents: instead of retyping the dates, I would like a function picking the dates from the english out of stock. column A: item number column B: item description column C: ETA I was thinking about VLOOKUP but I didn't manage to formulate it so as to report the date. Can anyone help ? thanks carla |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
Why don't you apply a French date format for yor ETA cells?
Regards, Stefi €˛carla€¯ ezt Ć*rta: I have an out of stock list (updated twice a week) showing the ETA when an item is due back in stock. The out of stock list is in english and I need to create one for my french agents: instead of retyping the dates, I would like a function picking the dates from the english out of stock. column A: item number column B: item description column C: ETA I was thinking about VLOOKUP but I didn't manage to formulate it so as to report the date. Can anyone help ? thanks carla |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
Is the data sorted by item number?
If so then put the item number that you want to search for in D1 and in E1 =VLOOKUP(D1,A1:C3,3) - this will return ETA in E1 This assumes that the data is in range A1:C3 - change as required. If the data is not sorted by item number you will probably need INDEX MATCH - I will post something later edvwvw carla wrote: I have an out of stock list (updated twice a week) showing the ETA when an item is due back in stock. The out of stock list is in english and I need to create one for my french agents: instead of retyping the dates, I would like a function picking the dates from the english out of stock. column A: item number column B: item description column C: ETA I was thinking about VLOOKUP but I didn't manage to formulate it so as to report the date. Can anyone help ? thanks carla -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
Here is an example:
In A1 thru C10: 100nm cat 7/10/2008 200nm dog 7/9/2008 300nm mouse 7/5/2008 400nm lion 7/14/2008 500nm ant 7/3/2008 600nm flea 6/19/2008 700nm rat 7/13/2008 800nm bird 7/3/2008 900nm bee 7/9/2008 1000nm warthog 6/6/2008 in another cell: =VLOOKUP("500nm",A1:C10,3) This will report 7/3/2008 once the cell has been formatted as a date -- Gary''s Student - gsnu200790 "carla" wrote: I have an out of stock list (updated twice a week) showing the ETA when an item is due back in stock. The out of stock list is in english and I need to create one for my french agents: instead of retyping the dates, I would like a function picking the dates from the english out of stock. column A: item number column B: item description column C: ETA I was thinking about VLOOKUP but I didn't manage to formulate it so as to report the date. Can anyone help ? thanks carla |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
the data is sorted by item number. I tried what you said but it gives me
00/01/00, it doesn't pick the right date. I have: item no. (col B) - description (col C) - ETA (col D), then I have price, qty, total etc in the following columns, then again item no. (col. K) - description (col L) - ETA (col M). I put: =VLOOKUP(K35,'[tarif 05.10.07.xls]Sheet1'!$A:$Q,13) But it gives me 00/01/00. and if I drag it down it gives always 00/01/00. Can you help ? or can you suggest any other way (even not sorted by item number). thx ! "edvwvw via OfficeKB.com" wrote: Is the data sorted by item number? If so then put the item number that you want to search for in D1 and in E1 =VLOOKUP(D1,A1:C3,3) - this will return ETA in E1 This assumes that the data is in range A1:C3 - change as required. If the data is not sorted by item number you will probably need INDEX MATCH - I will post something later edvwvw carla wrote: I have an out of stock list (updated twice a week) showing the ETA when an item is due back in stock. The out of stock list is in english and I need to create one for my french agents: instead of retyping the dates, I would like a function picking the dates from the english out of stock. column A: item number column B: item description column C: ETA I was thinking about VLOOKUP but I didn't manage to formulate it so as to report the date. Can anyone help ? thanks carla -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |