You could also do this with a VLOOKUP using an approximate match and a key table.
See attached, bonus 2 column and key added, left @Glenn's as was for comparison. Both work but VLOOKUP may be more salable. If you make the key a table and use structured refs you could even expand the key without needing to update the VLOOKUP.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kimbdalr 
Register To Reply
Bookmarks