Microsoft Office Forums Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
 Register FAQ Search Today's Posts Mark Forums Read

#1
09-12-2016, 06:38 PM
 innkeeper9 Windows 7 32bit Office 2007 Novice Join Date: Aug 2016 Posts: 20
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
09-13-2016, 01:22 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,727

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
#3
09-13-2016, 08:59 PM
 innkeeper9 Windows 7 32bit Office 2007 Novice Join Date: Aug 2016 Posts: 20

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 Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post ekeithjohnson Excel 6 08-28-2014 01:16 PM teza2k06 Excel 2 03-18-2014 01:21 PM Catbert Excel 18 08-25-2013 07:38 PM skyline255 Excel 0 09-19-2012 05:05 PM cklassen Excel 1 05-19-2012 01:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:40 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top