+ Reply to Thread
Results 1 to 4 of 4

Vlookup not working for 0

  1. 11-19-2013, 10:38 AM #1
    Joshex
    Joshex is offline
    Registered User
    Join Date
    11-19-2013
    Location
    london, england
    MS-Off Ver
    Excel 2013
    Posts
    3

    Vlookup not working for 0

    grades.xlsx Can anyone help me please? The vlookup is returning an error for students with a grade of 0 and I cant figure out why?
    Reply With QuoteRegister To Reply
  2. 11-19-2013, 10:43 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Vlookup not working for 0

    Hi,

    Your formulas in column J are set to return "0", which is a text value, whereas your 0 in cell M4 is numerical. Change your formula in e.g. J4 to:

    =IF(AVERAGE(E4:F4)<40,0,(AVERAGE(E4:F4)*0.2)+(G4*0.6)+(0.2*SUM(AVERAGE(LARGE(B4:D4,{1,2})))))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 11-19-2013, 05:22 PM #3
    Joshex
    Joshex is offline
    Registered User
    Join Date
    11-19-2013
    Location
    london, england
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Vlookup not working for 0

    Thankyou so much!
    Reply With QuoteRegister To Reply
  4. 11-20-2013, 05:28 AM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Vlookup not working for 0

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup not working
    By excellearner121 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2013, 08:57 PM
  2. [SOLVED] Vlookup is not working and giving =vlookup(B2,$T$2:$U$135,2,false) this kind of values.
    By yogeshsharma1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2013, 04:08 PM
  3. [SOLVED] Vlookup is not working.
    By nur2544 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2012, 03:35 AM
  4. Vlookup not working
    By vamshi57 in forum Excel General
    Replies: 8
    Last Post: 01-28-2010, 07:42 AM
  5. vlookUp not working
    By dgkindy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2008, 03:59 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1