In the following formula I’d like to add If $B30 is #N/A, then the result of the formula should be 0. Does anyone have a suggestion on how to include this into my formula? I’ve tried adding an If statement before the index formula and that does not work. Basically if the result of the following formula is #N/A because cell $B30 is #N/A I’d like the formula to result in 0.
=INDEX('E handset detail'!$D$11:$O$829,MATCH($B30,'E handset detail'!$A$11:$A$829,0),MATCH($B$26,'E handset detail'!$D$10:$O$10,0))
Thank you in advance
Bookmarks