Auto populating cell values from list based on criteria (Source: Separate excel file)

I am trying to find a way to auto populate cells (either entire row or individial columns) based on criteria value in a dropdown list.
The source data is located in a separate excel file. This excel file is generated from a database and will update monthly. The column headers will remain the same always.

The criteria lists will be made in the "City", "Product", "Indication" fields in the Customer tool file. So basically, if I choose "City" the data from the Database.xls file corresponding to city should be displayed in the area below in the Customer tool.

Both files can be downloaded from here:

http://basbous.dk/test/customertool.xls
http://basbous.dk/test/database.xls


I am thinking autofilter with some kind of macro to take care of the dynamic source list?
I am not sure how to go about this

Hi,

Thank you for that awesome formular. I am dissecting it at the moment trying to figure out what it does exactly

Let's say I want to add another criteria: Product and Indication. So if I write eg "Product1" it will only show Product1 names for people living in that city (first criteria). Is the difficult to accomplish?

I think I understand that concept - or maybe not quite. If I change the lookup column to match a new criteria (say "Indication") - won't it just overwrite the previous criteria? That's what happened to me. Shouldn't there be some kind of condition check "If criteria equals "Product1" && criteria equals Indication4" only display those results.

I've attached the file again. Here I've made the first criteria as Product which shows all names, indications and cities connected to that product. What I want to do is, is then select an indication and city which will further narrow/filter the search. So if product criteria equals "Product1" and indication criteria equals "Indication4" , the only name to appear should be John Basbous as this would be the only match. This is where I thought some sort of condition check should be implemented.

Does this make any sense?

customertool.xlsdatabase.xls