formula to show data for branch

hello

having some trouble or rather logic approach

i have 3 drop down list (region, district, branch), all dependent on on another *although im having some trouble showing branch*

-i would like:
in column E *see attached* for all zip codes to show for the corresponding branches
i.e. chicago-milwaukee is a district, if i select D "chicago"...colum N *red cell - formula not working* shows all zip codes, but when all zip codes have been shown for chicago, i want it to show milwaukee

formula in column E:
{=INDEX(Zip,SMALL(IF(_Branch='Master assignment sheet'!$D15,ROW(_Branch)-ROW(BranchStart)+1),COUNTIF('Master assignment sheet'!$E$15:$E15,$E15)),3)}

that is the logic errror im having....can someone pls help!!!!

Replace COUNTIF with ROWS,

=INDEX(Zip,SMALL(IF(_Branch=D$15,ROW(_Branch)-ROW(BranchStart)+1),ROWS(E$15:E15)),3)

Note: Your file has more 32000 rows data, So Array formula will slow down the calculation.

Hello Jw01,

I don't know about VBA. It is better to move your thread to Programming section. Send a request to a moderator to move it to programming section.

You have already District & Branches in Col_M:N so define a name as Dist on refers to,

Please Login or Register  to view this content.

Then in the DV list use =Dist

hello haseeb

sory for the confusion

Column D should be the branches that show in column C
i.e.


i just dont get the formula thxs

See the attached for dependent DV. You can add/delete region, dist, entries etc...