Extracting data from multi dropdown lists
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.
|