Using Excel as a Database

Dear all,

I have a challenge of using Excel as a Database, where user can select the items and rates by different suppliers.

The condition ; i have

1. Different city (now is 4 cities)
2. Different supplier(now is 3 suppliers)
3. Supplier rates (all submitted in same format)

Now i want to do is , for the user

• Select the city
• Select the supplier
• Select the services they provide; their rates will be returned

How can i do it ? I have attached on what i did
I can not figure it out how i can incorporate the "Supplier" into the filtering


Appreciate your help



Eric

Dear Marvin

Thanks for your comment

I have a 2nd thought

I use a "work around"method, to concentrate the supplier and services, and Index and Match this "concentrated"coloumn

See attached.

It seems work but i hope there is a better way.