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!