Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vlookup (Excel 2003)

    hi there
    having trouble with the vlookup.
    in cell I17 i want to use the Vlookup table i have produced to find whether the grades in cells (G17:G56) are fail, pass, merit and to return the data fail, pass or merit in cell I17. i have made tried and failed can you please show me where im going wrong and explain why my function that is already in cell I17 doesnt work.
    thank you as always kitty

    =VLOOKUP("Result",Grade_Lookup_Table,15,G17:G56)
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Vlookup (Excel 2003)

    <P ID="edit" class=small>(Edited by sdckapr on 16-Jan-08 07:43. Added Question on scores <40)</P>How about:
    =VLOOKUP(G17,Grade_Lookup_Table,2)

    Steve
    PS what does the score of "34" get. It is <40 and nothing is listed for <40....

  3. #3
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup (Excel 2003)

    hi there i still cant get it to work like you said for under 40 is a fail
    where am i going wrong?

  4. #4
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup (Excel 2003)

    hi there is there any way round this as ive been trying all kinds
    <40 under 40= Fail
    <60 under 60= Pass
    >75 over 75= Merit

    thanks kitty

    i have reattached the new sheet, as it only produces merits and i dont no what more i can do to change it.
    Attached Files Attached Files

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Vlookup (Excel 2003)

    If 0 - 40 is a fail
    40-60 is a Pass
    >75 is merit

    What about 60-75??

    The cells in M must be numbers to use Vlookup.

    Your lookup table should be like:
    <table border=1><td></td><td align=center>M</td><td align=center>N</td><td align=center valign=bottom>16</td><td align=right valign=bottom>0</td><td valign=bottom>Fail</td><td align=center valign=bottom>17</td><td align=right valign=bottom>40</td><td valign=bottom>Pass</td><td align=center valign=bottom>18</td><td align=right valign=bottom>60</td><td valign=bottom>???</td><td align=center valign=bottom>19</td><td align=right valign=bottom>75</td><td valign=bottom>Merit</td></table>

    This means:
    from >=0 by <40 is a fail
    >=40 and <60 is a Pass
    >=60 and <75 is something you have not listed
    >=75 will be Merit

    You have numeric divisions you need 4 descriptions.

    You would use in I17:
    =VLOOKUP(G17,Grade_Lookup_Table,2)

    Steve

  6. #6
    New Lounger
    Join Date
    Feb 2004
    Location
    Findlay, Ohio, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup (Excel 2003)

    Hi,
    A quick fix would be: Change your lookup table to 1 - fail, 40 - pass, 76 - merit
    This would mean, 1 to 39 = fail, 40 to 75 = pass and 76 and over = merit
    Also, grade or points reference should be cell reference (G18 etc.)
    Max

  7. #7
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup (Excel 2003)

    hi there it still doesnt work can you please try for your self on my attached file using the vlookup table called "vlookup"

    thanks kitty
    Attached Files Attached Files

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Vlookup (Excel 2003)

    In I17:
    =VLOOKUP(G17,vlookup,2)

    You have:
    =VLOOKUP("Result",vlookup,2)

    And the text "Result" is not found in the list, and it is <0 so it gives the value in cell N15 which is blank. The result is the value of zero(0)

    Steve

  9. #9
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup (Excel 2003)

    ohhhhhhhhhhhhhhhhhhh thank you so much

    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Posting Permissions

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