Hello all -
I have an excel sheet which generates a price of a particular piece based on several criteria.


In my data validation, I have this formula - =OFFSET(Price!$C$2:$C$21,0,A3-1)

When the user enters a diameter for a particular piece (or row), this generates the possible "widths" for that diameter which becomes a drop-down.

For some diameters, the widths are BLANK, or they don't exist in that range C2:C21.

Is there any way to filter out the blanks so that my drop-down contains only numbers, without using nested if statements?

Thank you!