Hi all,
I have the following formula that works for any number over=IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($BJ$3:$BJ$5002=C3)*($BK$3:$BK$5002=I3)),$BV$3:$BV$5002),"Backorder"))
This seems to work fine but not when BV returns 458429
Any ideas why?
Thanks
I have the following formula that works for any number over=IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($BJ$3:$BJ$5002=C3)*($BK$3:$BK$5002=I3)),$BV$3:$BV$5002),"Backorder"))
This seems to work fine but not when BV returns 458429
Any ideas why?
Thanks