Dynamic VLookups in Pivots
Hello,
I have a pivot table I am pulling from using a vlookup. The problem is that when the pivot is unfiltered, the data populates no problem. When it gets filtered, some months have no data and therefore mess up the vlookup. Do you know how to avoid this so that I can depend on the numbers that are being pulled in as correct?
Thank you!
You get better help on your question if you add a small excel file, without confidential information.
Please also add manualy the expected result in your file.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks