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.

 

[nardagus]

Yes. That's because DV formulas are set to analyze up to 10th worksheet row.
Check the RED, bolded and underlined entry below. With this you tell CountA formula to count nonempty cells in range from 3rd to 10th row.
If you need more rows to check just change it to suit your needs. I.e. If the biggest company has 50 employees just change this parameter to 53 (because employee list starts from 3rd row).

=OFFSET(INDIRECT(ADDRESS(3;MATCH(B15;A1:BR1;0);1));0;0;COUNTA(INDIRECT(ADDRESS(3;MATCH(B15;A1:BR1;0);1)&":"&ADDRESS(10;MATCH(B15;A1:BR1;0);1)));1)

 

[BURTPRI]

That is SO AWESOME THANK YOOOUUU!!!!!!!!!!!!! ???????