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:

Alto HospicioTarapacá


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