Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in pivot table
I use a pivot table for reporting. In the reporting sheet, I use the function
to look up in the pivot table: =if(iserror(vlookup....;false));0;vlookup(....;fal se)). This works. But only if the pivot table shows all products. If I choose only one or several product I want to see the month figures from, the formula returns with zero's. Only if I choose "show all", the formula works. Who recognizes this and what can I do to solve it? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in pivot table
Sounds like you need to do your vlookup on the database not the pivot table
because when you filter the pivot table you are getting rid of some of the data. If the data's not there, your vlookup is not going to find it. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Ink" wrote: I use a pivot table for reporting. In the reporting sheet, I use the function to look up in the pivot table: =if(iserror(vlookup....;false));0;vlookup(....;fal se)). This works. But only if the pivot table shows all products. If I choose only one or several product I want to see the month figures from, the formula returns with zero's. Only if I choose "show all", the formula works. Who recognizes this and what can I do to solve it? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
VLOOKUP Dates in a Pivot Table | Excel Discussion (Misc queries) | |||
Vlookup/Pivot table question | Excel Worksheet Functions | |||
Vlookup in a pivot table | Excel Worksheet Functions | |||
vlookup in a pivot table | Excel Worksheet Functions |