Help: Auto generation of ID number, delivery date

[sha001]

Dear friends,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I would appreciate if you kindly help me to prepare an excel sheet with Auto generation of ID number, delivery date , once I select customer name and enter receive date.<o></o>
In sheet 2: I have already entered the customer name, ID no and delivery timeline.
In sheet 1: If I select “Name of the customer” from dropdown and enter the “Receive date”

<o></o>
I want three fields to be populated automatically: ID no, Delivery date and time remaining from today.

<o></o>
To calculate days remaining from today, I used
=IF(D4>TODAY(),D4-TODAY(),"")

I need help to generate Customer ID and delivery date.

Thanks in advance for your help.<o></o>
Sha

 

[shyy]

If I am reading this correctly, all you need is the VLOOKUP function. I just tested it myself, and VLOOKUP seem to auto populate the customer name from sheet2.

=VLOOKUP($A$2,Sheet2!$A$2:$D$5,2,FALSE)

 

[sha001]

If I am reading this correctly, all you need is the VLOOKUP function. I just tested it myself, and VLOOKUP seem to auto populate the customer name from sheet2.

=VLOOKUP($A$2,Sheet2!$A$2:$D$5,2,FALSE)

Hi,
Thank you verymuch.
Yes it is working.

Could you please help me to calculate the delivery date based on received date.


Customer Delivery time line <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
A 45 Working days <o></o>
B 33 calendar days<o></o>
C 2months<o></o>
D 2 years

If I select the customer name from drop down in field (A2)
And enter received date in field (B2)
How to get the " delivery date" in field (C2) based on time line

Thanks in advance

 

[sha001]

Hi