yogi_For Values In Column D LookUp Corresponding Values In Column B Of Sheet Named 'brands'

                                         Google Spreadsheet   Post  #1589
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-05-2014
post by Adrian Bacuta: (https://productforums.google.com/forum/#!mydiscussions/docs/FZyZoSCJT0E)
Need help creating a formula (if a certain string found in cell give discount)

Hi there ,

Is the first time posting here for help so i might talk nonsense but i will try my best.We have created  a google docs spreadsheet where we keep

track of our sold t-shirt and we need a formula to do the following :

1.In column D we have entirely a data validation by list of items ( brand names in our case ).

2.If a certain brand name from the list is selected we want to return a percentage number (ex: 25%)  in a new cell on the same row.

Thank you

--------------------------------------------------------------------------------------------------------------------------