Cell C34 has a drop down menu, E34 has this formula =IF(C34<>"",VLOOKUP(C34,Table7_Percentage,2,FALSE) ,""), so when I choose Joe from the drop down, abc goes in E34, if I choose Sandra then def goes into E34.



This all works terrific [thanks to Jeffbrown for the vlookup]. The next step is to have the amount figured in H34, it is a percentage of Cell H16, so for now I use the drop down and then I have to manually put in =SUM(H16* correct %) based on who has been chosen Joe, Sandra etc.

But, is there a way to do something with that vlookup so that it will figure the correct percentage to put into H34, like adding another column to the Table7_Percentage, which has each persons % and then be able to also pass that =SUM(H16* the correct %) in that H34 cell?

Hope that made sense. Thanks for any help.

Ruth