Column Matching for state abbreviation.

[Warrior Golf]

Hello. I have column H filled with state names in full. I would like to quickly change all state names into a 2 letter abbreviation. I'm assuming I can do a "VLOOKUP" formula? I do have a separate spreadsheet which has state names in column A and state abbreviation in column B.

This is an older "VLOOKUP" formula that I've tried to modify but have been unsuccessful: =VLOOKUP(LEFT(H2,3)+0,'SheetWithCodes'!$A$1:$B$430,2,FALSE)

Thanks

 

[BrianJN1]

Do you want to permanently replace the Full names on your first sheet, the one with Col H, with the abbreviations?

If so, give this some thought (I've used Sheet1 and Sheet 2 for my example):
Insert a column After Col H on Sheet1 and insert the formula:=VLOOKUP(H1,Sheet2!A$1:B$430,2,FALSE) in cell I1.
Drag the formula down the length of your states. When complete copy And then use PASTE Values to overwrite the formulae. Then delete Column H. Your new Col H will now be abbreviations.

Does that satisfy?

 

[Warrior Golf]

Perfect! Thank You!