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

557 thoughts on “Excel IF and vlookup combination help

  1. 국가기술자격증위조

    Wow! This can be one particular of the most beneficial blogs We ave ever arrive across on this subject. Actually Wonderful. I am also an expert in this topic therefore I can understand your hard work.

  2. Aplicativo Tv Digital Android

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. check my source

    I’m amazed, I must say. Rarely do I come across a blog that’s both equally educative and engaging, and without a doubt, you have hit the nail
    on the head. The issue is something which not enough men and
    women are speaking intelligently about. I am very happy I came across this in my hunt for something concerning this.

  4. cngadget

    This blog is really entertaining as well as factual. I have found many helpful things out of it. I ad love to come back again soon. Thanks a bunch!

Comments are closed.