Help with vlookup and date

[ingenuity]

I have a list of maybe 1000 domain names in excel, let's say

column a is domain names
column b is expiration date

out of the 1000 names, i have renewed 100 of them but not in any particular order. How do i do a vlookup and find the 100 names within the list of 1000 and add 1 yr to the date within the column b cell?
thanks for the help

 

[WinteE]

Is there anything specific on the names that you renewed ?

 

[jasonb75]

The only way you could do it with a formula would be something like

Excel Workbook
	A	B	C	D	E
1	Domain	Expiry		renewed	New expiry
2	Domain1	06/06/2011		Domain2	07/03/2011
3	Domain2	07/03/2010		Domain6	31/01/2012
4	Domain3	06/02/2011		Domain12	05/01/2011
5	Domain4	19/08/2010
6	Domain5	01/02/2010
7	Domain6	31/01/2011
8	Domain7	28/04/2010
9	Domain8	02/03/2011
10	Domain9	17/02/2011
11	Domain10	18/03/2010
12	Domain11	29/04/2011
13	Domain12	05/01/2010
14	Domain13	14/01/2010
15	Domain14	26/11/2010
16	Domain15	10/02/2010
Sheet4

But you wouldn't be able to directly change the date in column B, that would require a vba solution.

 

[ingenuity]

Thank you, I will give it a try.