I need to add drop down lists to select from into B2 based off the formula result in A2 (formula is in A3) and will return Colour or Size.
The lists in D & E columns will be on a different tab within my document and should form the drop down list based off the result in A2, i.e. A2 = Colour, drop down list is column D, A2 = Size, drop down list is column E.
The lists in D & E columns will be on a different tab within my document and should form the drop down list based off the result in A2, i.e. A2 = Colour, drop down list is column D, A2 = Size, drop down list is column E.