dates

[carla]

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

 

[Stefi]

Why don't you apply a French date format for yor ETA cells?

Regards,
Stefi

„carla†ezt írta:

 

[edvwvw via OfficeKB.com]

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

 

[Gary''s Student]

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

 

[carla]

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 !