I understand and have used basic VLOOKUP. This one is (at least to me) a bit trickier. The source ss is a listing of zipcode ranges (column 1) with their corresponding sales reps (column2). Now, I want to be able to enter a zipcode and have it return the name of the corresponding sales rep. No problem if EVERY zipcode is listed, but there are thousands. Also, they are NOT in a nice sorted logical order. AND there are "ranges" in each cell. A sample of the data is below. SO, is there anyway to lookup a range within a cell???? Make sense? Or any other ideas to take this EXISTING ss and make it usable
COL1 COL2
21000..25999, 59000..59999 Jim
37501..37501,48000..38599 Sue
38000..38500, 60000..61000 Ken
Notes:
1. there are multiple zipcode ranges in each cell
2.In each cell the zipcode ranges are separated beg to end with a ".."
3.the ranges are then separate with a ","
4.I could sort COL2 based on the value of the FIRST entry, but don't think this helps because within a cell there are many ranges, HOWEVER, within a cell the ranges are in lowest to highest order.
COL1 COL2
21000..25999, 59000..59999 Jim
37501..37501,48000..38599 Sue
38000..38500, 60000..61000 Ken
Notes:
1. there are multiple zipcode ranges in each cell
2.In each cell the zipcode ranges are separated beg to end with a ".."
3.the ranges are then separate with a ","
4.I could sort COL2 based on the value of the FIRST entry, but don't think this helps because within a cell there are many ranges, HOWEVER, within a cell the ranges are in lowest to highest order.