G
Guest
I have some large spreadsheets with customer addresses and need to assign a
sales manager to each of then. The sales area is assigned by the first
letters in the postcode. I.e GL7 5TQ, GL means David, W15 0JD, W means Rob.
I have checked the IF function but that's limited to 7 functions and I have
some 70 odd postcodes to assign. I also tried the Lookup function, but I
didn't get it to work. ( not saying it works but I couldn't get it to
work...;-)
Has anyone a solution for this problem?
Cheers
Lars
Excel 2003
sales manager to each of then. The sales area is assigned by the first
letters in the postcode. I.e GL7 5TQ, GL means David, W15 0JD, W means Rob.
I have checked the IF function but that's limited to 7 functions and I have
some 70 odd postcodes to assign. I also tried the Lookup function, but I
didn't get it to work. ( not saying it works but I couldn't get it to
work...;-)
Has anyone a solution for this problem?
Cheers
Lars
Excel 2003