+ Reply to Thread
Results 1 to 4 of 4

vlookup function

  1. #1
    Registered User
    Join Date
    10-02-2003
    Posts
    80

    vlookup function

    I need help with vlookup function.

    I need the formulae to look up csi in f22 and in table u22-v29 and
    return the figure in s column corrosponding to value in f22.
    In example if it is 80 % the value in g22 will be 0.75 %
    if the value is 50 % g22 wll be -1.00 %

    Thanks much

    vikkam
    Last edited by vikkam; 08-25-2006 at 11:37 AM.

  2. #2
    Biff
    Guest

    Re: vlookup function

    Hi!

    You should change your layout.

    Swap U22:U29 with S22:S29

    Then:

    =IF(F22="","",VLOOKUP(F22,S22:U29,0))

    Biff

    "vikkam" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I need help with vlookup function.
    >
    > I need the formulae to look up csi in f22 and in table u22-v29 and
    > return the figure in s column corrosponding to value in f22.
    > In example if it is 80 % the value in g22 will be 0.75 %
    > if the value is 50 % g22 wll be -1.00 %
    >
    > Thanks much
    >
    > vikkam
    >
    >
    > +-------------------------------------------------------------------+
    > |Filename: sc_payplan_svcwrtr_120805.zip |
    > |Download: http://www.excelforum.com/attachment.php?postid=4107 |
    > +-------------------------------------------------------------------+
    >
    > --
    > vikkam
    > ------------------------------------------------------------------------
    > vikkam's Profile:
    > http://www.excelforum.com/member.php...fo&userid=1266
    > View this thread: http://www.excelforum.com/showthread...hreadid=492063
    >




  3. #3
    Biff
    Guest

    Re: vlookup function

    Ooops!

    Typo

    > =IF(F22="","",VLOOKUP(F22,S22:U29,0))


    Should be:

    =IF(F22="","",VLOOKUP(F22,S22:U29,3))

    Biff

    "Biff" <[email protected]> wrote in message
    news:%[email protected]...
    > Hi!
    >
    > You should change your layout.
    >
    > Swap U22:U29 with S22:S29
    >
    > Then:
    >
    > =IF(F22="","",VLOOKUP(F22,S22:U29,0))
    >
    > Biff
    >
    > "vikkam" <[email protected]> wrote in
    > message news:[email protected]...
    >>
    >> I need help with vlookup function.
    >>
    >> I need the formulae to look up csi in f22 and in table u22-v29 and
    >> return the figure in s column corrosponding to value in f22.
    >> In example if it is 80 % the value in g22 will be 0.75 %
    >> if the value is 50 % g22 wll be -1.00 %
    >>
    >> Thanks much
    >>
    >> vikkam
    >>
    >>
    >> +-------------------------------------------------------------------+
    >> |Filename: sc_payplan_svcwrtr_120805.zip |
    >> |Download: http://www.excelforum.com/attachment.php?postid=4107 |
    >> +-------------------------------------------------------------------+
    >>
    >> --
    >> vikkam
    >> ------------------------------------------------------------------------
    >> vikkam's Profile:
    >> http://www.excelforum.com/member.php...fo&userid=1266
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=492063
    >>

    >
    >




  4. #4
    Registered User
    Join Date
    10-02-2003
    Posts
    80
    got it.
    thanks much

+ 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