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:
| City | State |
| Iquique | Tarapacá |
| Alto Hospicio | Tarapacá |
| ??? | Tarapacá |
| Camiña | Tarapacá |
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!
