Hello, I used Excel for years but have not for a while and am back to being a newbie. Basically, I have created a list of two-letter codes to match the names of the 29 Indian States, e.g. AndhraPradesh AP, Bihar BH etc. Now there is a humongously long column of election-data (something like 600 million people will vote over the next month or so) which has Andhra Pradesh appearing say 700 times followed by Bihar appearing 200 times etc. I want the latter list to check against the former list and yield the initials AP for Andhra Pradesh and BH for Bihar etc. Have sweated all day with LookUp, If, Match etc without success. Any help gratefully received.
I was younger when I was an excel expert, now I am rusty ..
Bookmarks