I have a formula pulling in sales data from a pivot table. I am using the formula =iferror(vlookup(a38,'pivot - sold 2020'!a:b,2,false),0.01)
i have put the 0.01 at the end so that if there's no entry for that sku in the pivot table it at least puts something in the cell to divide by.
But no matter what number i put at the end it still shows 0 in the box which causes a divide error.
Can any-one help?
Bookmarks