Let,
A2 is a drop list with source: Sale,Purchase
B2 is also a drop list with source: =IF($A2="Sale",List Sale,List Purchase)
Before that, In name manager, List Sale=Apple Juice, Orange Juice, Coconut Shake and List Purchase= Apple, Orange, Coconut
Now if you can see..if I select Sale in A2, automatically in B2 will contain Apple Juice, Orange Juice and Coconut Shake and it works for the other too. Then copy both cell and paste into multiple column.. but the problem is that my drop list is not searchable like not giving narrowed down suggestion.
I dont want any VBA or Micro solution because I need it in classic formula. Thanks.
Bookmarks