You can manipulate the pivot table to have the correct headers and rows necessary for the vlookup to work. I need the highlighted fields to auto calculate based on the pivot table. I've attached a sample spreadsheet. Thank you in advance.
You can manipulate the pivot table to have the correct headers and rows necessary for the vlookup to work. I need the highlighted fields to auto calculate based on the pivot table. I've attached a sample spreadsheet. Thank you in advance.
Last edited by Vernell10; 08-23-2016 at 08:59 AM.
Eh? What VLOOKUP? Where are the highlighted fields??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Last edited by Vernell10; 08-23-2016 at 09:01 AM.
I need the vlookup to pull from the pivot table.
Last edited by Vernell10; 08-23-2016 at 09:00 AM.
Sorry the original attachment was incorrect. Sorry for the confusion. Please use Vlookup and pivot table sample spreadsheet.
sorry for the delay. I was on a boat... So what you have posted is not a pivot table, just a rough representation of one; so I cannot really give you an exact answer!! I can easily get a formula that gives you the answers from the material that you posted, but it'll probably be useless in you real data:
Column M
=IFERROR(ABS(INDEX('pivot table sample'!$D$2:$D$100,MATCH("'"&$A2,'pivot table sample'!$A$2:$A$100),0)),"")
Column P
=IFERROR(ABS(INDEX('pivot table sample'!$C$2:$C$100,MATCH("'"&$A2,'pivot table sample'!$A$2:$A$100)+1,0)),"")
If your data in column are not numbers formatted to look like text, but are ACTUALLY numbers (they are text in your posted sheet), then omit this bit: "'"& from the MATCH formula.
My main Q, however, is why you just don't use SUMIF or SUMIFS from the raw data, rather than making life more difficult for yourself...
I attached the actual pivot table. I can easily use a getpivotdata formula but when I drag I get the same results. So you are saying a SUMIF formula would be easier? You can provided which formula you think is best .
can you explain WHY you want those values on another sheet, since the data is already available in the pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
M2
=ABS(SUMIF('pivot table'!B:B,A2,'pivot table'!D:D))
P2
=ABS(SUMIF('pivot table'!B:B,A2,'pivot table'!C:C))
The two sheets are just combined for this forum. But at my job these are two separate spreadsheets
Perfect!!! Thank you so much!
Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks