Using VLOOKUP to convert US State Abbreviations ...

[Admin]

Hi Greg,

Welcome to ExcelFox !!

Convert the list into a table. In Excel select the range > click on Insert menu > Table > OK.

Now you can use this table across the workbook.

The formula would be:

=VLOOKUP(A2,Table1,2,0)

[gamouning]

Hi,

Thanks, this reply is very helpful however I need to re-state my request. I wish to create a custom function (i.e. Abbrev2StName) which can be accessed from any Excel worksheet. The Abbrev2StName function would call a cell location containing the state abbreviation and the result is the State name in a different cell location. For example:

The content of cell A2 contains CA
The content of cell B2 contains =Abbrev2StName(A2)
The result in cell B2 contains = California

Thanks in advance for your reply.

Kind regards,
Greg