

Thread Tools  Display Modes 
#1




Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
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 
#2




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
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be) Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank. 
#3




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 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
VLOOKUP Formula?  ekeithjohnson  Excel  6  08282014 01:16 PM 
Vlookup formula  teza2k06  Excel  2  03182014 01:21 PM 
I think I need an IF/AND & VLOOKUP formula here  Catbert  Excel  18  08252013 07:38 PM 
IF + VLOOKUP formula help  skyline255  Excel  0  09192012 05:05 PM 
Can't get formula to recognize correct data  cklassen  Excel  1  05192012 01:25 AM 