Getting Results with a Validation List

  • Thread starter Thread starter RJ Swain
  • Start date Start date
R

RJ Swain

Hello and thank you for your help. Hopefully, I can explain what I am looking
for and it is a simple formula!

I have a drop down list in cell B3 (example: list is apple through zebra).

In cell O3, I would like a certain percentage show in the O3 cell when the
user selects their choice in cell B3. So if the user selects APPLE then the
percentage pertaining to APPLE would appear in the O3 cell.

Thank you
 
No need to calculate a percentage. Example Apple = 5% Bear = 7% Zebra = -.5%
if the user selects Apple there is just a set percentage associated to Apple
or Bear, etc..
 
Back
Top