lornagreenwood
New Member
- Joined
- Jul 24, 2009
- Messages
- 11
I'm working on a project in which I have 50 states + DC listed by 2-letter abbreviation, and want to return a value in another column that will be a non-unique number (some will duplicate in the second column.)
Also need to do this same operation with first column (state) and third column, which also is comprised of non-unique numbers.
Will anyone please help a user out? It seems simple, yet I don't know where to start.
Hlookup, lookup & pivot tables seem to not be a fit for this.
Also need to do this same operation with first column (state) and third column, which also is comprised of non-unique numbers.
Will anyone please help a user out? It seems simple, yet I don't know where to start.
Hlookup, lookup & pivot tables seem to not be a fit for this.