Results 1 to 8 of 8

Selecting from a list of text according to a range of values

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    4

    Post Selecting from a list of text according to a range of values

    I am trying to create a formula in Excel that will select from a list of different text statements in response to a varying figure in another column. I’d really value. I’m not an advanced Excel user

    A pictorial way of putting it is
    A Between 0 and 10
    B Between 11 and 30
    C Between 31 and 40
    D Between 41 and 60
    E Between 61 and 70
    F Between 71 and 100

    x If x = A then return “one”
    If x = B then return “Two”

    Etc

    Etc


    One

    Two

    Three

    Four

    Five

    six

    I’ve played around with IF and MATCH and INDEX and DGET but can’t quite manage it.
    Would be very grateful for help
    Thanks
    Peter

    Sorry it's not as clear as it was within the table form that dropped out as i posted!
    Attached Files Attached Files
    Last edited by Peter Robin; 12-03-2012 at 09:38 AM. Reason: title not clear

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