Microsoft Office Forums Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-12-2016, 06:38 PM
innkeeper9 innkeeper9 is offline Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Windows 7 32bit Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Office 2007
Novice
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
 
Join Date: Aug 2016
Posts: 17
innkeeper9 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-13-2016, 01:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Windows 7 64bit Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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.
Reply With Quote
  #3  
Old 09-13-2016, 08:59 PM
innkeeper9 innkeeper9 is offline Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Windows 7 32bit Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Office 2007
Novice
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
 
Join Date: Aug 2016
Posts: 17
innkeeper9 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula VLOOKUP Formula? ekeithjohnson Excel 6 08-28-2014 01:16 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Vlookup formula teza2k06 Excel 2 03-18-2014 01:21 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula I think I need an IF/AND & VLOOKUP formula here Catbert Excel 18 08-25-2013 07:38 PM
IF + VLOOKUP formula help skyline255 Excel 0 09-19-2012 05:05 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula Can't get formula to recognize correct data cklassen Excel 1 05-19-2012 01:25 AM


All times are GMT -7. The time now is 08:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft