array formula results with empty cells

[Kmitchell]

I need assistance modifying the below array formula. I want to add that if the results return "" to make it "". Currently if a result is blank its returning a 0.

IF(F2="","",(INDEX('MOD LOOKUP'!$M$2:$M$176,MATCH(1,('Billed Unit Details'!$F2='MOD LOOKUP'!$L$2:$L$176)*('Billed Unit Details'!$I2='MOD LOOKUP'!$K$2:$K$176),0))))


I tried to modify the array as shown below but it returns #VALUE! in the instances where the cell should be "".

=IF(F3="","",(INDEX('MOD LOOKUP'!$M$2:$M$176,MATCH(1,('Billed Unit Details'!$F3='MOD LOOKUP'!$L$2:$L$176)*('Billed Unit Details'!$I3='MOD LOOKUP'!$K$2:$K$176),0)="","",IF(F3="","",(INDEX('MOD LOOKUP'!$M$2:$M$176,MATCH(1,('Billed Unit Details'!$F3='MOD LOOKUP'!$L$2:$L$176)*('Billed Unit Details'!$I3='MOD LOOKUP'!$K$2:$K$176),0)))))))

Any suggestions?

 

[jondavis1987]

IF(F2="","",(INDEX('MOD LOOKUP'!$M$2:$M$176,MATCH(1,('Billed Unit Details'!$F2='MOD LOOKUP'!$L$2:$L$176)*('Billed Unit Details'!$I2='MOD LOOKUP'!$K$2:$K$176),"to make it"))))

try that

 

[Kmitchell]

Thank you! That did not give expected results, but I was successful with this

=IF(IF(F399="","",(INDEX('MOD LOOKUP'!$M$2:$M$176,MATCH(1,('Billed Unit Details'!$F399='MOD LOOKUP'!$L$2:$L$176)*('Billed Unit Details'!$I399='MOD LOOKUP'!$K$2:$K$176),0))))=0,"",IF(F399="","",(INDEX('MOD LOOKUP'!$M$2:$M$176,MATCH(1,('Billed Unit Details'!$F399='MOD LOOKUP'!$L$2:$L$176)*('Billed Unit Details'!$I399='MOD LOOKUP'!$K$2:$K$176),0)))))