+ Reply to Thread
Results 1 to 3 of 3

Is a formula the best approach?

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Is a formula the best approach?

    I am having some trouble wrapping my mind around how to achieve something. If you have any suggestions about the best approach to try I would really appreciate it.

    I have a chart:

    Age
    15-19 Male Female
    Excellent >= 108 >= 68
    Very Good 98-107 60-67
    Good 90-97 53-59
    Fair 79-89 48-52
    Poor <= 78 <= 47

    I also have a similar chart for ages 20-29, 30-39, 40-49, 50-59 and 60-69, but with slightly different values.

    Now what I want to do is have some kind of formula, or maybe a vlookup is a better approach (never done this before but someone mentioned it to me as a possible option, have no idea how to do it though). I want to say something like If between the ages of 15-19 and male and value >= 108 then display "Excellent". Another example would be 15-19, female, value between 53-59, so display "Good". But I would also need to differentiate between the other age ranges and the values in their tables. I really have no idea where to start with this. Any suggestions would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Is a formula the best approach?

    Sorry I cant really follow your example.
    Create a sample workbook and show the current state and layout a possible desired state.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Is a formula the best approach?

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help for v-lookup approach instead of manually cell linking approach - Excel 2010
    By Mirisage in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-31-2013, 01:32 PM
  2. Replies: 10
    Last Post: 08-10-2012, 03:06 AM
  3. [SOLVED] Simplify: Copy Column Removing Non-Zero Values (formula approach)
    By Filibuster in forum Excel General
    Replies: 7
    Last Post: 05-30-2012, 11:16 AM
  4. Best Formula approach to conditionally change color on a list
    By springbok in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2006, 03:32 PM
  5. [SOLVED] Data Flipping - Approach with formula?
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2005, 04:09 PM

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