Index/match formula with division returning #value due to empty cell

[Anitykk]

I have a formula =IFERROR(INDEX('Shop II YTD'!$BJ:$BJ,MATCH($A6,'Shop II YTD'!$A:$A,0)),"")/$G6 that returns a #Value error when G6 is empty.

Is there a way to correct the formula so it returns a blank or zero?

Thank you for your help!

 

[Saba Sabaratnam]

Move division into the formula as shown below.

IFERROR(INDEX('Shop II YTD'!$BJ:$BJ,MATCH($A6,'Shop II YTD'!$A:$A,0))/$G6,"")

Or put another IFERROR around it the first formula.

Kind regards

Saba

 

[Peter_SSs]

You could also do it this way, saving the attempted division calculation when G6 is empty

=IF($G6="","",IFERROR(INDEX('Shop II YTD'!$BJ:$BJ,MATCH($A6,'Shop II YTD'!$A:$A,0))/$G6,""))