Dependent dropdownlist on Excel table with subheaders

[BURTPRI]

Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough.
I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each header (the Company).
I need to create three cells with dropdown lists for each subheader category based on the main dropdown list where the user chooses the Company.
Please note that Row 1 brings the headers, Row 2 the subheaders and Raws 3 and 4 the data collected.
I hope I was able to express my challenge well.
Thank you very much if you read this far.

 

[BURTPRI]

Oh sure I'm sorry I'm learning how to behavior here.
I'm so desperate for help on this matter that I've also posted this question in other forums here are the links:

SOLVED Dependent dropdown list with subheader categories

Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough. I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each...

www.excelforum.com

Dependent dropdown list with subheader categories

Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough. I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each...

chandoo.org

Best answer so far is here thanks to @nardagus

 

[nardagus]

Just accept this error. When B6 is empty it can render such error, but once you chose a company DV will work. Unless there is an error in a formula

 

[BURTPRI]

Have company DV in B6, still find same error

 

[nardagus]

Ok. This error is definitely not because of B6 was empty. There really seems to be an error in a formula, but I copied DV formula from my first post and it worked... Let me put my excel somewhere on Internet and I'll get back to you.

 

[BURTPRI]

OMG you're so awesome thank you so much for your help!!!!

 

[nardagus]

Here:

Workbook.xlsx

1 file sent via WeTransfer, the simplest way to send your files around the world

we.tl

This is wetransfer

 

[Fluff]

Change the semi-colons to commas and it should then work.

 

[BURTPRI]

WOW it's beautiful and works perfectly! Thank you very very much God bless you I wish you a whole life of happiness haha!!

 

[nardagus]

WOW it's beautiful and works perfectly! Thank you very very much God bless you I wish you a whole life of happiness haha!!

Glad to help. Good luck with changing stuff to suit your needs

Cheers and thanks for feedback.

 

[BURTPRI]

Hello @nardagus and I'm sorry to bother you again. I can't express enough how thankful I am for all your help... I've been trying unsuccessfully to understand why the formulas of your 2nd solution (talking about the last file you sent) only returns data of up to 8 rows down the subheader... All data inserted from the 9th row down is not being returned. Any ideas?