Good Evening all,
I have the following formula that works perfectly but if DG* and DI8 are blanket returns a "0"
Is there a way to just return "" instead of the "0"
=IFERROR(LOOKUP(2,1/(('Chase Details'!$E$10:$E$1009=DG8)*('Chase Details'!$F$10:$F$1009=DI8)),'Chase Details'!$Q$10:$Q$1009),"")
Many thanks
I have the following formula that works perfectly but if DG* and DI8 are blanket returns a "0"
Is there a way to just return "" instead of the "0"
=IFERROR(LOOKUP(2,1/(('Chase Details'!$E$10:$E$1009=DG8)*('Chase Details'!$F$10:$F$1009=DI8)),'Chase Details'!$Q$10:$Q$1009),"")
Many thanks