Hi,
Can I please ask for some help on removing the
I have tried just removing these lines but it seems to make the whole formula crash
=IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($CN$3:$CN$10002=C3)*($CU$3:$CU$10002=V3)*($FP$3:$FP$10002<>"")),$FP$3:$FP$10002),"Backorder"))
Thanks
Can I please ask for some help on removing the
$FP$3:$FP$10002 part of this formula as I no longer need this argument
I have tried just removing these lines but it seems to make the whole formula crash
=IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($CN$3:$CN$10002=C3)*($CU$3:$CU$10002=V3)*($FP$3:$FP$10002<>"")),$FP$3:$FP$10002),"Backorder"))
Thanks