When I try to divide a number from a different sheet using vlookup with a Pivot table counted number. It does not just divide by that number but it tries to pull some data from the pivot table and then displays the wrong value.
