View Single Post
 
Old 07-28-2018, 01:04 AM
Idkevin Idkevin is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2018
Posts: 1
Idkevin is on a distinguished road
Default 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.
Reply With Quote