Results 1 to 2 of 2

Thread: IF(test, vlookup, vlookup) HELP

  1. #1

    IF(test, vlookup, vlookup) HELP



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am creating an invoice and I need a certain cell to calculate out the correct fee in accordance to what time of the year their registering as well as what payment method their using. I know this is done with an IF(test, vlookup, vlookup) break down. But I'm having a little trouble 'starting'.
    I ALSO know that the 'IF' needs to establish whether or not a play is using the payment plan or not, and the vlookups needs to return the correct fee in accordance to if their using the payment, depending on the date they are paying.

    but I also need for the results to return nothing if a second player is not being registered.


    I will provide the attachment of my workbook. The invoice worksheet, the section with 'player1 fee' is where I need the formulas to go, and on 'table worksheet' is the fees.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try this formula:

    =IF(OR($E$18="",$E$40=""),"",VLOOKUP($I$3,Tables!$C$3:$E$6,IF($E$18="Regular Fee",2,3)))


Posting Permissions

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