That makes sense, so then, Col F would then have a number corresponding to each state? But you're saying I would have to define the state values myself in col E, there is no way for excel to just automatically figure out which values there are? Listing 50 states isn't too bad, but would be awesome to know how to get around it if possible, just for future reference.