Results 1 to 11 of 11

Index Match - nested If (less than/greater than statements)

Threaded View

kelea Index Match - nested If (less... 08-28-2009, 01:32 PM
DonkeyOte Re: Index Match - nested If... 08-28-2009, 01:48 PM
kelea Re: Index Match - nested If... 08-28-2009, 02:58 PM
DonkeyOte Re: Index Match - nested If... 08-28-2009, 03:01 PM
kelea Re: Index Match - nested If... 08-28-2009, 03:07 PM
kelea Re: Index Match - nested If... 08-28-2009, 04:21 PM
DonkeyOte Re: Index Match - nested If... 08-28-2009, 04:26 PM
kelea Re: Index Match - nested If... 08-28-2009, 04:40 PM
  1. #1
    Registered User
    Join Date
    08-28-2009
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    6

    Index Match - nested If (less than/greater than statements)

    Hi,

    I am having some trouble with an excel function. I have a worksheet of data where if the cell gives be A, go to a reference table, match A then perform multiple if statements.

    Ref table:
    Row/Coll A B C D
    1 A 1 5 Good
    2 A 6 10 Better
    3 A 11 15 Best
    4 B 1 10 Good
    5 B 11 20 Better
    6 B 21 30 Best

    So if the inputs were A and 7, give me Better

    But if they were B and 25, give be Best

    Input cells are E1 & E2, to spit out the number in E3

    MANY THANKS!!
    Last edited by kelea; 08-28-2009 at 02:57 PM. Reason: not enough details

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