Hi,
The formula below works well until it encounters the divide by zero issue. I'm off somewhere, can you please assist so that the result shows '0' instead of '#DIV/0'! ?
=IFERROR(VLOOKUP($A40,'Status Modified_01'!$A$2:$U$479,COLUMN('Status Modified_01'!H22),FALSE),0)/E34
Thanks
Bookmarks