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.

S/n	Company	State	Code
1	Georgia Waters	Georgia	GA
2	Creamlight	New York	NY

<tbody>
</tbody>

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))