stevebrooks01
Board Regular
- Joined
- Feb 20, 2008
- Messages
- 88
Dear Fellow Excel Geeks:
The totality of the problem is:
We have our own in-house database of customers (about 20,000). These customers are assigned to specific Sales people.
We also buy in new databases and allocate these leads to Sales people.
Before we can allocate them, we need to de-dupe them against our existing in-house database.
The business challenge is that; for example; Cables & Wireless Seychelles would need to be allocated to the Sales person that looks after Cable & Wireless.
We need a formula that will find these duplicates.
And not just strings within strings.
I did stumble across this on the internet, but I am not sure
a) If it would work
b) How to change ‘Cities’ to a generic TEXT finder
Partial string lookups (#partialstring)
The following is a reply from Debra Dalgleish in response to looking up part of the cell. For example, if the cell contains “Dallas, Texas” it is to pick up the city of Dallas without regard to the comma and the remainder after the comma.
=VLOOKUP(LEFT($A2,LEN($A2)-FIND(",",$A2)-1),Cities,2,FALSE)
any help is GREATLY appreciated.
Whoever solves this gets a pint (or ten) the next time you're in the UK.
Cheers
Brooksy
The totality of the problem is:
We have our own in-house database of customers (about 20,000). These customers are assigned to specific Sales people.
We also buy in new databases and allocate these leads to Sales people.
Before we can allocate them, we need to de-dupe them against our existing in-house database.
The business challenge is that; for example; Cables & Wireless Seychelles would need to be allocated to the Sales person that looks after Cable & Wireless.
We need a formula that will find these duplicates.
And not just strings within strings.
I did stumble across this on the internet, but I am not sure
a) If it would work
b) How to change ‘Cities’ to a generic TEXT finder
Partial string lookups (#partialstring)
The following is a reply from Debra Dalgleish in response to looking up part of the cell. For example, if the cell contains “Dallas, Texas” it is to pick up the city of Dallas without regard to the comma and the remainder after the comma.
=VLOOKUP(LEFT($A2,LEN($A2)-FIND(",",$A2)-1),Cities,2,FALSE)
any help is GREATLY appreciated.
Whoever solves this gets a pint (or ten) the next time you're in the UK.
Cheers
Brooksy
