Lookup value of referance sheet

[Glenda Johnson]

I know i have done this like 30 yrs ago I just can't remember how. I have a table with column A (City), Column B (state). I want to lookup city on a different sheet (same workbook) and return the state. Example below

Reference Tabletyped in separate sheet
BozemanMTFlorencereturn state here
FresnoCA
FlorenceOR
NampaID

 

[xlstime]

Hi Glenda Johnson,

You can simply use vlookup to get State.

sample sheet attached for your reference.

I know i have done this like 30 yrs ago I just can't remember how. I have a table with column A (City), Column B (state). I want to lookup city on a different sheet (same workbook) and return the state. Example below

Reference Tabletyped in separate sheet
BozemanMTFlorencereturn state here
FresnoCA
FlorenceOR
NampaID