Results 1 to 6 of 6

IF STATEMENT COMBINED WITH VLOOKUP?

This is a discussion on IF STATEMENT COMBINED WITH VLOOKUP? within the Excel Questions forums, part of the Question Forums category; I am trying to evaluate a cell, and depending on what the value is, enter either a 0 or go ...

  1. #1
    New Member
    Join Date
    Oct 2002
    Location
    Schaumburg, IL
    Posts
    40

    Default IF STATEMENT COMBINED WITH VLOOKUP?

    I am trying to evaluate a cell, and depending on what the value is, enter either a 0 or go thru with the VLOOKUP.

    Here is the formula I am using in cell E4
    =IF($E$3,"Wg Missing",0)=VLOOKUP($B$2,FEB!$A$14:$CH$43,7)

    Add'l info: Cell E3 is doing an evaluation of it's own --
    =IF($B$2<>E$264,"Wg Missing","February")


    I keep getting error #VALUE so I know I'm not doing this right. I'd appreciate any ideas you all have. Thank you for your help.

  2. #2
    AJ
    AJ is offline
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478

    Default Re: IF STATEMENT COMBINED WITH VLOOKUP?

    Hiya,

    To do the formula as you've got it, try...
    =IF($E$3="Wg Missing",0,VLOOKUP($B$2,FEB!$A$14:$CH$43,7))

    Or, if you wanted to dispense with the additional formula that you've got in column E and do it in one go, try...

    =IF($B$2<>E$264,0,VLOOKUP($B$2,FEB!$A$14:$CH$43,7))

    Rgds
    AJ

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526

    Default

    Depending on your table I suspect just a VLOOKUP would be required.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    2,370

    Default

    IF STATEMENT COMBINED WITH VLOOKUP?
    I am trying to evaluate a cell, and depending on what the value is, enter either a 0 or go thru with the VLOOKUP.

    Here is the formula I am using in cell E4
    =IF($E$3,"Wg Missing",0)=VLOOKUP($B$2,FEB!$A$14:$CH$43,7)

    Add'l info: Cell E3 is doing an evaluation of it's own --
    =IF($B$2<>E$264,"Wg Missing","February")


    I keep getting error #VALUE so I know I'm not doing this right. I'd appreciate any ideas you all have. Thank you for your help.
    ----

    =IF($E$3="Wg Missing",0,VLOOKUP($B$2,FEB!$A$14:$CH$43,7)

    Do you really need full width of A14:CH43?

  5. #5
    New Member
    Join Date
    Oct 2002
    Location
    Schaumburg, IL
    Posts
    40

    Default IF STATEMENT COMBINED WITH VLOOKUP

    Thank you so much for your help (and so quick, too!). It's perfect.

  6. #6
    New Member
    Join Date
    Apr 2012
    Location
    Los Angeles
    Posts
    2

    Default Re: IF STATEMENT COMBINED WITH VLOOKUP

    This was a huge help. Thank you. Follow up question. Can I control the formatting of the # (i.e. Dollars vs. a Percentage) that results from this formula?

    Here's my formula: =IF(K12="RevShare",VLOOKUP(J12,products!$P$7:$Q$8,2,FALSE),VLOOKUP(E12,products!$M$16:$N$31,2,FALSE))

    If RevShare is in K12, then a percent will appear in the cell where this formula is entered.

    But if not, then I would like to post a regular $ value, not a percentage.

    Is that possible?

    Thanks!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com