IF return of 0 then show "Ordered"

[ExcelRoy]

hi,

I have the formula below which works perfectly until it returns 0 if nothing is found

Can I have the formula changed to show "Ordered" if 0 is found

=IF(ET3&EV3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(('Chase Details'!$F$10:$F$1009=ET3)*('Chase Details'!$G$10:$G$1009=EV3)),'Chase Details'!$U$10:$U$1009),"Backorder"))

Many thanks for any help

 

[Col Delane]

[TABLE="width: 1619"]
<tbody>[TR]
[TD]It's a little difficult to comment without knowing the nature of your workbook, data and what the LOOKUP function is doing, but ....

By "... if nothing is found" I presume you mean that the LOOKUP is finding the Lookup_value but there is no attached value to return, rather than it not finding the Lookup_value as that should return a #NA error which your IFERROR is handling.

If so, will the following solve your problem?

IF( ET3 & EV3 = "",
"",
IF( IFERROR( LOOKUP( 9.99999999999999E+307, 1 / ( ( 'Chase Details'!$F$10:$F$1009 = ET3 ) * ( 'Chase Details'!$G$10:$G$1009 = EV3 ) ), 'Chase Details'!$U$10:$U$1009), "Backorder") ) = 0, "Ordered",
IFERROR( LOOKUP( 9.99999999999999E+307, 1 / ( ( 'Chase Details'!$F$10:$F$1009 = ET3 ) * ( 'Chase Details'!$G$10:$G$1009 = EV3 ) ), 'Chase Details'!$U$10:$U$1009), "Backorder") ) )[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]