+ Reply to Thread
Results 1 to 3 of 3

help needed in VLOOKUP function

  1. #1
    Registered User
    Join Date
    11-25-2005
    Posts
    4

    help needed in VLOOKUP function

    HI everyone

    I have a small error in this formula:

    =VLOOKUP(E48,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
    A-";95,"A"},2)

    the error occures when i enter a value between ( 90-95) which I suppose to get ( A-) but i got an error. and the rest of the function works very good.


    I'm waiting your help very soon.


    Thanks

  2. #2
    Guest

    Re: help needed in VLOOKUP function

    Hi

    You don't say what the error is. Anyway, the formula works fine for me
    (Excel 2000).

    Andy.

    "DaredEvil590" <[email protected]>
    wrote in message
    news:[email protected]...
    >
    > HI everyone
    >
    > I have a small error in this formula:
    >
    > =VLOOKUP(E48,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
    > A-";95,"A"},2)
    >
    > the error occures when i enter a value between ( 90-95) which I suppose
    > to get ( A-) but i got an error. and the rest of the function works very
    > good.
    >
    >
    > I'm waiting your help very soon.
    >
    >
    > Thanks
    >
    >
    > --
    > DaredEvil590
    > ------------------------------------------------------------------------
    > DaredEvil590's Profile:
    > http://www.excelforum.com/member.php...o&userid=29085
    > View this thread: http://www.excelforum.com/showthread...hreadid=488202
    >




  3. #3
    Bob Phillips
    Guest

    Re: help needed in VLOOKUP function

    You did avoid the line wrap didn't you?

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "DaredEvil590" <[email protected]>
    wrote in message
    news:[email protected]...
    >
    > HI everyone
    >
    > I have a small error in this formula:
    >
    >

    =VLOOKUP(E48,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,
    "
    > A-";95,"A"},2)
    >
    > the error occures when i enter a value between ( 90-95) which I suppose
    > to get ( A-) but i got an error. and the rest of the function works very
    > good.
    >
    >
    > I'm waiting your help very soon.
    >
    >
    > Thanks
    >
    >
    > --
    > DaredEvil590
    > ------------------------------------------------------------------------
    > DaredEvil590's Profile:

    http://www.excelforum.com/member.php...o&userid=29085
    > View this thread: http://www.excelforum.com/showthread...hreadid=488202
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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