Referencing a table to lookup a cell

Occasional Visitor

Hi all,

 

Basically I have a table with a list of clients where the column in their city they're from is filled in but the state isn't. I want to use a table as reference to autofill the gaps for the states.

 

I've tried using vlookup and index/match but haven't been able to fix it. 

 

Here's an example of what I want to be able to do:

 

This is the main table where I have my client information database:

CityState
IquiqueTarapacá
Alto HospicioTarapacá
???Tarapacá
CamiñaTarapacá

 

In this case, I want A4 (???) to be autofilled referencing a table.

 

Thank you in advance and hope someone knows how this can be done!

0 Replies