My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

16 table in to 1|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / 16 table in to 1|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
16 table in to 1
Avatar
Jay Shukla

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
December 28, 2018
sp_UserOfflineSmall Offline
1
April 30, 2019 - 4:07 pm
sp_Permalink sp_Print sp_EditHistory

I have 16 tables with me in 2 sheets. (please refer attachment for your reference)

I am looking to convert all this table in the drop-down list in the following the order,

1) Metro or Non-metro

2) individual or family

3) Plan

5) Price & age

 

in the end, I am looking for to be matched.

 

What should be the right approach?

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 880
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
2
May 1, 2019 - 4:57 pm
sp_Permalink sp_Print

Hello Jay,

I an not sure that I have grasped fully what it is you want to do, for example, what is to be matched?

Any way, from what I understand this blog article comes close to what you want to do. If not, then please give more information about expected end result.

Avatar
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands

VIP
Members
Level 2
Forum Posts: 346
Member Since:
April 21, 2015
sp_UserOfflineSmall Offline
3
May 1, 2019 - 6:22 pm
sp_Permalink sp_Print

Hi Jay, do you want all the data in just one table to use that as a reference table or such?

Or do you want to have a kind of lookup through this data (which in my opinion is not possible in this setting, you have to transform some things for that).

What is the outcome of the action you want?

Frans

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28647

 

Member Stats:
Guest Posters: 49
Members: 32830
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen