D
Dean Hewer
Greetings NG,
Simple request. Excel file has multiple sheets.
Sheet 1 National MASTER CUSTOMER LIST (About 2100 records).
Sheet 2 Regions List customers. A=customer number, B to F is the address of
the location (About 2300 records).
Sheet 3 - 33 are the sales reps. Each of them has customers assigned to
them. A=customer number, etc.
In the Cell B1 on each of these sheets is the Reps Name.
The range of customers is from A3 to A100
Here is what I like to do.
In Sheet 2, H10, I want to place a formula that will find the matching
customer number and then place the Reps name in that cell. So it is looking
for a match of the customer number in SHEET to and finding that match
somewhere on sheets 3 - 33. If it does not find a match, I would like to
enter the value 'UNASSIGNED'.
Any help would be greatly appreciated. I will check this post from time to
time. Thanks
_____________________________
Dean Hewer
Simple request. Excel file has multiple sheets.
Sheet 1 National MASTER CUSTOMER LIST (About 2100 records).
Sheet 2 Regions List customers. A=customer number, B to F is the address of
the location (About 2300 records).
Sheet 3 - 33 are the sales reps. Each of them has customers assigned to
them. A=customer number, etc.
In the Cell B1 on each of these sheets is the Reps Name.
The range of customers is from A3 to A100
Here is what I like to do.
In Sheet 2, H10, I want to place a formula that will find the matching
customer number and then place the Reps name in that cell. So it is looking
for a match of the customer number in SHEET to and finding that match
somewhere on sheets 3 - 33. If it does not find a match, I would like to
enter the value 'UNASSIGNED'.
Any help would be greatly appreciated. I will check this post from time to
time. Thanks
_____________________________
Dean Hewer