I have a pivot table that has a list of some names and totals (LIST A) and another pivot table that has a another complete list of names (LIST B) and want to fill in the totals from LIST A.
I want to do a VLOOKUP from LIST B comparing names and pulling the totals from LIST A. Each list has the name and the totals in separate colum.
Name is column A, total is colum B
LIST A List B
Brown, Lisa 4 Brown, Lisa
Burton, John 22 Burton, John
Good, Gilda 2 Dillon, Matt
Parker, Dave 17 Good, Gilda
Parker, Dave
One major problem is that Column B has a complete listing of people and column A will not always have the same people.
Is VLOOKUP the best formula to use for this?
Is there a problem doing this with pivot tables?
I've been using two different books and can't figure it out.
You say the 2nd list is a Pivot Table... is that correct ?
If it's I think you'll need to elaborate on the sources etc... I'm not quite sure how you intend to populate the 2nd PT from data within the first ?
If on the other hand List B is just a basic listing of names then you can use the SUMIF function from 2nd column in List B against List A - that will return 0 for those names listed in List B which are not present in List A. See XL Help for more info.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks