Reference data

D Nyman

D Nyman

Good afternoon. I would like the hub cell to populate based on the city cell in my current sheet

i created a data table and also a separate sheet with the references that detail the relationship between them. Below is the sheet sorted for just one of the hubs.

I tried Vlookup and was unable to determine the correct values. The alternative seems to be a very complicated IF statement. Is anyone able to help? Thank you in advance.

Paul Newcome

Do you have the city field listed in the reference table? What are you wanting to use to match on to determine the appropriate hub?

D Nyman

I appreciate you responding. The town on that reference table is the city. I can change the field name. I would like to input the town and have the HUB column auto populate.

Paul Newcome

In that case you would use something along the lines of

=INDEX({Reference Table Hub Column}, MATCH(City@row, {Reference Table Town Column}, 0))