Forum Discussion
How do I create a formula based on a drop down list choice
Good Afternoon, I am trying to set up a new spreadsheet which minimises the workload required each time info is inputted. Is it possible for a cell formula to change based on the choice from a dro...
Use
=PRODUCT(A2:C2,XLOOKUP(B7,$F$2:$F$4,$G$2:$G$4))
or
=A2*B2*C2*XLOOKUP(B7,$F$2:$F$4,$G$2:$G$4)
