I have the customer information in Tab called Customer Names. I got the code to work in sheet2, How do I setup
A) When I try adding the values to the next cell down it copies it from the first value.
B) When I delete in sheet 2 the customer's code, it still has the rest of the information.
<tbody>
</tbody>
<tbody>
</tbody>
A) When I try adding the values to the next cell down it copies it from the first value.
B) When I delete in sheet 2 the customer's code, it still has the rest of the information.
Customers Names | A | B | C | D | E | F | G | H |
1 | Acct# | Name | Address | Unit/ Ste | City | State | Zip | |
2 | Bn20 | Bagl | 57213 | apt1 | Bklyn | ny | 11220 | |
3 | Bo12 | Busi | 5303 | unit 7 | Queens | Ny | 11219 | |
4 | Mg53 | Ywb | 1349 | Ste 3 | Bklyn | NY | 11741 | |
5 | ||||||||
6 |
<tbody>
</tbody>
SHEET2 | A | B | C | D | E | F | G |
1 | bn20 | Bagl | 57213 | apt1 | Bklyn | ny | 11220 |
2 | This is the value for above | VLOOKUP($A2,'Customer Names'!$A$2:$I$99,2,0) | VLOOKUP($A2,'Customer Names'!$A$2:$I$99,3,0) | VLOOKUP($A2,'Customer Names'!$A$2:$I$99,4,0) | ETC | ETC | |
3 | | ||||||
4 |
<tbody>
</tbody>