sing2trees1983
New Member
- Joined
- Feb 3, 2006
- Messages
- 26
Hello everyone. I have a list of "numbers" which consists of three letters followed by six numbers. Batches will belong to different clients. E.g. ABC100000 to ABC110000 belongs to client A, ABC110001 to ABC120000 belongs to client B etc.
I would really like members of staff to enter a number and the vlookup function will show the client. Is it possible to do this without listing all the number range options individually?
Hope that makes sense and a huge thank you for your help in advance!
I would really like members of staff to enter a number and the vlookup function will show the client. Is it possible to do this without listing all the number range options individually?
Hope that makes sense and a huge thank you for your help in advance!