=IF(ISERROR(Your_Formula),0,Your_Formula)

=IF(ISERROR(VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38
MTD'!$A$3:$E$410,5,FALSE),0,VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38
MTD'!$A$3:$E$410,5,FALSE))

--
Kevin Backmann


"rmeister" wrote:


The following Formula is what I am using. I get the result of #DIV/0!
If I want this to return 0 for this error how would I write the
following formula.

=VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38
MTD'!$A$3:$E$410,5,FALSE)

Thank You In Advance.


--
rmeister
------------------------------------------------------------------------
rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163
View this thread: http://www.excelforum.com/showthread...hreadid=544750