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)
Hi Hans_Vogelaar
Thank you for your help on both of my posts.
I am having an issue with the XLOOKUP formula used above. Reaosn being I have excel 2021 whereas my colleague currently has excel 2016 which i believe XLookup doesnt work in.
Is there a formula which would work for both 2016 and 2021?
Cheers
Thank you for your help on both of my posts.
I am having an issue with the XLOOKUP formula used above. Reaosn being I have excel 2021 whereas my colleague currently has excel 2016 which i believe XLookup doesnt work in.
Is there a formula which would work for both 2016 and 2021?
Cheers