All,
I've been stuck on this problem for a few days now.
I am building a sheet for work that needs three drop downs, the first selects the row title (of which many are repeated), the second selects the column header and the third gives you the the options in the table below. Please see my formula below.
=OFFSET('Lookups-Master Events'!B3,MATCH($C10,'Lookups-Master Events'!$B$4:$B$64,0),MATCH($D10,'Lookups-Master Events'!$C$3:$H$3,0),COUNTIFS('Lookups-Master Events'!$B$4:$B$64,C10))
I get the right amount of options but a lot of times there are blanks in the data and the drop down can show 10 options and 10 blanks (which show up as 0 if you paste the formula into excel vs the data validation page).
I need a way to try and remove these blanks from the drop down data.
Please let me know if you need any more information
Thank you!
Bookmarks