Wow, banging my head since 8:30 this morning on this one (still in pajamas!). Trying to do a dependent percentile formula from a table. The setup:

1. SheetA contains two dependent drop-downs, DD1 and DD2. (no problems here)
2. Based on selection in DD2, percentile formula calculates from corresponding table on SheetB
3. Two criteria: 1)DD2 and 2) SheetB column header (ex. age)

Spelled out, I select State (DD1) and dependent County (DD2) from dropdowns. Database on SheetB is then referenced according to selections, column AA is selected (hard-coded to correspond to age) and the 75th percentile is calculated based on values within now-defined column.

Can't get very far - any suggestions?

Thanks!