Hi i havent use excel in a long time.


I want to have a multi dropdrown lists for a UIWith dropdown list

eg country, city, service / place
And then i was it to display the deteails description and the data.

Eg if the user picked doctor i was it to show
Name (data)
Address (data)
Type of doctor (data)
The description will b different. if they pick school r shopping centre.

I have sheets for different services /places
As the data on each service would b very different

Would i just used 2 vlookup. 1 vlookup for the data and 1 for the descriptions that on the same sheet as the data

R am i doing thing completely wrong

Thanks for any help i get.