Vba

[akpflow]

Good day sir/ma,
I have an excel sheet that has about 5000 companies in 52 USStates.
In my existing sheet, I have only s/n, company, state. I need to insert the US codes for their corresponding states into the sheet. See the tables below for better illustration.
How can I implement this?
I think vlookup can do this?
Need help.

[TABLE="width: 500"]
<tbody>[TR]
[TD]S/n
[/TD]
[TD]Company
[/TD]
[TD]State
[/TD]
[TD]Code
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Georgia Waters
[/TD]
[TD]Georgia
[/TD]
[TD]GA

[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Creamlight
[/TD]
[TD]New York
[/TD]
[TD]NY
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you

 

[Muhammad_Usman]

Did you have code in separate column ?

 

[akpflow]

Did you have code in separate column ?

I can't have any code but I'm open to any method

 

[Muhammad_Usman]

Assume you have states name and code list in G:H column
Put this formula in D2

=INDEX(H2:H55,MATCH(C2,G2:G55))