Excel IF and vlookup combination help

=IF(SUM($K2+$N2+H2)-$M2<0,VLOOKUP($B2,’Container QTY’!$A$2:$B$219,2,FALSE),”0″) 

 

Hello – i am not sure how to further expand the formula where the container value will be higher than a value in cell “O2”. I guess is there a way to use the return value from vlookup and multiply that by a number giving result greater the O2. ???

By: izi15

Leave a Reply

Your email address will not be published. Required fields are marked *