Log In
Register
Home
July 11, 2017
Offline
Hi There,
I'm trying to find a way that when I select a group from the drop-down list the associated hotels to that group appear, I have attached an example of the output required.
Any help gratefully accepted.
Thanks
Paul
See Answer
VIP
Trusted Members
June 25, 2016
Offline
Hi Paul
Give this a try.
It uses ARRAY formulas so you must press CTRL+SHIFT+ENTER instead of ENTER when you edit the formula.
Hope this helps.
Sunny
July 11, 2017
Offline
Thanks Sunny
Great help
July 11, 2017
Offline
Hi Sunny,
I tried applying the formula to my spreadsheet but could not get it to work, not sure if the issue is because the lookup values are on another worksheet within the workbook?
Any help gratefully accepted
Regards
Paul
VIP
Trusted Members
June 25, 2016
Offline
Hi Paul
Give this a try.
Sunny
July 11, 2017
Offline
Hi Sunny,
I'm still not able to get the formula to work on my worksheet? Is it because in my worksheet the Hotel column is before the Hotel Group column? and my workbook is sorted by Hotel where as yours is by Hotel Group?
Finally your formula has { } these brackets, not sure where these have come from?
So sorry to be a pain, perhaps you could update the formula in the attached so I can see where I'm going wrong?
Thanks
Paul
VIP
Trusted Members
June 25, 2016
Offline
Hi Paul
Please refer attachment.
The formulas are ARRAY formulas and need to be completed by CTRL+SHIFT+ENTER instead of ENTER.
The curly brackets {} are automatically inserted by Excel. You don't key them in.
You can refer https://www.myonlinetraininghu.....ay-formula for more detail about ARRAY formulas.
I could have given you a VBA solution but not sure if you would prefer it.
Whenever possible, make sure that your data is in a tabular format. It will make life more easy when you need to extract data using formulas,Pivot Table etc.
You can learn more about tabular format here https://www.myonlinetraininghu.....ata-format
Hope this helps.
Sunny
Answers Post
1 Guest(s)
