I need help extracting values if conditions are met. When a value is selected from the dropdown in A1 (for example Eastern), products associated with that dropdown can be selected from A4:A14. If western is selected, products list for Western can be selected from the dropdown list for Western in A4:A14 as well.
The formula I have set-up is pulling the values; nonetheless, cells that should be blanks are returning unintended values.
I need a formula to accurately capture the values for products that have corresponding values listed. Desired output is in GREEN color in column D
Sample file is attached.
Thanks for the assistance.
Bookmarks