+ Reply to Thread
Results 1 to 3 of 3

Formula Structure Error When Combining IF Function with VLOOKUP Function

  1. #1
    Forum Contributor
    Join Date
    12-16-2014
    Location
    Riverside, IA
    MS-Off Ver
    2010
    Posts
    156

    Formula Structure Error When Combining IF Function with VLOOKUP Function

    Hello,

    I get the error message, "Too Many Arguments for This Function" regardless of which formula used:

    =IF(D10="Female",VLOOKUP(D9,'Grading Scale'!$A$76:$D$88,4,TRUE,'Grading Scale'!$E$76:$H$88,4))

    =IF(D10="Female",VLOOKUP(D9,'Grading Scale'!$A$76:$D$88,4,TRUE,VLOOKUP(D9,'Grading Scale'!$E$76:$H$88,4,TRUE))

    What syntax and or configuration is not correct?

    Thank you,

    Patrick

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Formula Structure Error When Combining IF Function with VLOOKUP Function

    =IF(D10="Female",VLOOKUP(D9,'Grading Scale'!$A$76:$D$88,4,),VLOOKUP(D9,'Grading Scale'!$E$76:$H$88,4,)) this is correct, you forgot ")" in the first VLOOKUP

  3. #3
    Forum Contributor
    Join Date
    12-16-2014
    Location
    Riverside, IA
    MS-Off Ver
    2010
    Posts
    156

    Re: Formula Structure Error When Combining IF Function with VLOOKUP Function

    Tim201110,

    I added True to the end of both VLOOKUP'S and then it worked!

    Thanks for steering me in the right direction.

    Patrick

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining a SUM function and a VLOOKUP Function
    By mrmcmillanrevis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2015, 04:52 PM
  2. Tutoring: Complex Formula Structure Involving the IF Function
    By lila12 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-12-2015, 11:31 AM
  3. [SOLVED] Combining Text Function with Indirect Function
    By ninmjj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2013, 10:34 AM
  4. combining an IF function with an INDEX array function?
    By Chris.eagle99 in forum Excel General
    Replies: 1
    Last Post: 03-01-2012, 04:43 AM
  5. Replies: 8
    Last Post: 08-23-2010, 05:28 PM
  6. Combining a VLOOKUP and PRODUCT function
    By andrewc in forum Excel General
    Replies: 4
    Last Post: 09-11-2009, 08:03 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1