ok so here you have the first sheet
Excel Workbook |
---|
|
---|
| A | B | C | D | E |
---|
1 | Department | Name | Address | Phone | Email |
---|
2 | Accounting | Joe Smith | 123 A Street | 281-555-7171 | Smith@abc.com |
---|
3 | Finance | Karl Reiner | 355 City Avenue | 713-555-1122 | Reiner@abc.com |
---|
4 | Sales | Bob Ricker | 1515 County Line | 832-555-4000 | Ricker@abc.com |
---|
5 | Customer Service | Frank Ling | 350 City Court Ln | 281-555-7172 | Ling@abc.com |
---|
6 | Collections | Hooker Mannis | 311 Loveland Ave | 713-555-1123 | Mannis@abc.com |
---|
7 | HR | Carol Lovely | 1666 Constance Dr | 832-555-4001 | Lovely@abc.com |
---|
8 | Executive | Bill Jobs | 1124 A Street | 281-555-7173 | Jobs@abc.com |
---|
9 | Accounting | Steve Gates | 3356 City Avenue | 713-555-1124 | Gates@abc.com |
---|
10 | Finance | Mary Pierce | 15700 County Line | 832-555-4002 | Pierce@abc.com |
---|
11 | Sales | Connie Gaston | 2351 City Court Ln | 281-555-7174 | Gaston@abc.com |
---|
12 | Customer Service | Arnold Palmer | 3312 Loveland Ave | 713-555-1125 | Palmer@abc.com |
---|
13 | Collections | Tiger Woods | 1697 Constance Dr | 832-555-4003 | Woods@abc.com |
---|
14 | HR | Barbra Wings | 1525 A Street | 281-555-7175 | Wings@abc.com |
---|
15 | Executive | Carl Reins | 4357 City Avenue | 713-555-1126 | Reins@abc.com |
---|
16 | Accounting | Debbie Anston | 7517 County Line | 832-555-4004 | Anston@abc.com |
---|
17 | Finance | Debbie Winston | 2350 City Court Ln | 281-555-7176 | Winston@abc.com |
---|
18 | Sales | Ken Smith | 5310 Loveland Ave | 713-555-1127 | Smith@abc.com |
---|
19 | Customer Service | Phil Perry | 8670 Constance Dr | 832-555-4005 | Perry@abc.com |
---|
20 | Collections | Tom Longfellow | 4143 A Street | 281-555-7177 | Longfellow@abc.com |
---|
21 | HR | Terri Mercer | 7315 City Avenue | 713-555-1128 | Mercer@abc.com |
---|
22 | Executive | Bonnie Rath | 6522 County Line | 832-555-4006 | Rath@abc.com |
---|
|
---|
Excel 2003
then for the second sheet you setup like this
Excel Workbook |
---|
|
---|
| A | B | C | D | E |
---|
1 | Match Dept | Accounting | 3 | | |
---|
2 | Department | Name | Address | Phone | Email |
---|
3 | Accounting | Joe Smith | 123 A Street | 281-555-7171 | Smith@abc.com |
---|
4 | Finance | Karl Reiner | 355 City Avenue | 713-555-1122 | Reiner@abc.com |
---|
5 | Sales | Bob Ricker | 1515 County Line | 832-555-4000 | Ricker@abc.com |
---|
6 | | | | | |
---|
|
---|
Excel 2003Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
copy the formula down to several rows, it feels in blanks for the rows that aren't needed