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

Add a column to your lookup table with the percentages ( say it is the 3rd column) then =IF(C34<>"",H16*VLOOKUP(C34,Table7_Percentage,3,FALSE),"")

PS the SUM function in your formula is not necessary

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you so much. Sorry it took so long, but I could not get it to work, and after a while to stop being frustrated did some other things in the workbook. But, finally I went back and so simple a thing, I'd made a change which changed the cell. It works great and now things are so much easier

Thanks

Ruth