mas_lerdanch
Board Regular
- Joined
- Jun 25, 2007
- Messages
- 64
EmailPyreneesBookers.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
6 | Ref | Name | Pax | Resort | Board | From | Days | Email1 | CustomerID | ContactLastName | EmailAddress2 | |||
7 | 24508 | Inglis | 3 | LuzSt.Saveur | HB | 15/06/2008 | 3 | 24508 | Street | email1@web.com | ||||
8 | 24508 | Inglis | 8 | LuzSt.Saveur | HB | 15/06/2008 | 6 | 24508 | Pace | email@web.com | ||||
9 | 24508 | Inglis | 11 | Panticosa | HB | 11/06/2008 | 4 | 24508 | Jewell | email@web.com | ||||
10 | 16043 | Wood | 2 | LuzSt.Saveur | HB | 07/06/2008 | 6 | 16043 | Gray | email@web.com | ||||
11 | 7080 | Auger | 2 | LuzSt.Saveur | HB | 01/07/2008 | 14 | 7080 | Stevenson | emailx@web.com | ||||
12 | 20731 | Gray | 2 | LuzSt.Saveur | HB | 08/07/2008 | 5 | 20731 | Sheldrake | email@web.com | ||||
13 | 19843 | Cook | 2 | LuzSt.Saveur | HB | 10/08/2008 | 6 | 19843 | Williams | email@web.com | ||||
14 | 20731 | Gray | 2 | Panticosa | HB | 13/07/2008 | 6 | 20731 | Lunn | email@web.com | ||||
15 | 19843 | Cook | 2 | Panticosa | HB | 04/08/2008 | 6 | 19843 | Watson | email@web.com | ||||
16 | 25120 | Goldstraw | 2 | Panticosa | HB | 02/07/2008 | 10 | 25120 | Christie | email@web.com | ||||
17 | 8436 | Marshallsay | 1 | LuzSt.Saveur | HB | 02/07/2008 | 7 | 8436 | Watt | email@web.com | ||||
18 | 4322 | Burn | 2 | LuzSt.Saveur | HB | 14/06/2008 | 7 | 4322 | Ridley | email@web.com | ||||
19 | 19741 | Garbutt | 2 | LuzSt.Saveur | SC | 09/08/2008 | 7 | 19741 | Spafford | email@web.com | ||||
20 | 28655 | Ryrie | 4 | LuzSt.Saveur | HB | 17/07/2008 | 4 | 28655 | Matthews | email3@web.com | ||||
21 | 28655 | Ryrie | 4 | Panticosa | HB | 21/07/2008 | 6 | 28655 | Hooper | email3@web.com | ||||
22 | 20161 | Collier | 4 | LuzSt.Saveur | HB | 25/06/2008 | 7 | 20161 | Klosin | email3@web.com | ||||
23 | 16673 | Pope | 2 | LuzSt.Saveur | HB | 23/08/2008 | 7 | 16673 | Doyle | email3@web.com | ||||
Sheet1 |
Hi I am looking to make a formula in the Email1 column that looks at Column A and if the value in Column A is equal to the value in Column J i would like to display the email address in Column L.
Please help I am at a loss as to what to do.
Thanks in advance.
Mas