I want to convert the fill name of the US states into Abbreviations (For instance, Maryland to MD and so forth). In the ‘state’ column, I want to see the abbreviations. Here is my sample input file. Can anyone help? Thanks! InputFile_States.xlsx (9.7 KB)
@sangeethaneelavannan1 Thank you for the dictionary. I want to make it clear that I want the abbreviations are expected to be written sate names in the State Sheet from the States_abbr sheet after the vlookup. I am attaching the example. Sates_VlookUp.xlsx (17.0 KB)
Thanks