How to populate multiple fields from a table using one field in a dropdown?

[TheBearDen]

I have two apps that I use to track expenses and fuel usage with years of data.

In both of those apps I have five columns:

Location, Address, City/Town, Province and Lat/Long.

Currently I enter the data manually. However, I would like to be able to select and enter just the location and have the other four fields filled in automatically.

My data is there in the same sheet as a table other than the main table, all I need to know is how can I access it an make it work as described.

In the interim, I am using enumlist which allows me to select each field individually.

I think I have to use the valueif function, but am unsure how to do that.

My goals here are data accuracy, consistency, time saving and efficiency.

As well, I would like to be able to add and capture new data as required in those five fields.

Can anyone provide some guidance on this for me?

Any help is greatly appreciated.

Thanks.

P.S. Hopefully I posted this in the correct forum. If not where would be a better spot to post it?

As well, if required I can share the tables etc., but am unsure as how to do that.

Andy