+ Reply to Thread
Results 1 to 12 of 12

Get a value based on multiple Criteria Columns

  1. 07-19-2017, 01:45 AM #1
    luckyearl
    luckyearl is offline
    Registered User
    Join Date
    01-29-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Get a value based on multiple Criteria Columns

    Hi

    I need to get a value for Fittness Rating (Column G) based on age/ gender & Vmax on "Main " sheet. Criteria for Fittness rating is based Age, Gender and Vmax, summarised on sheet "Fittness Rating".

    Attached is workbook

    Plz help, Thank you
    Attached Files Attached Files
    Last edited by luckyearl; 08-06-2017 at 07:02 PM.
    Reply With QuoteRegister To Reply
  2. 07-19-2017, 01:48 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Get a value based on multiple Criteria Columns

    Welcome to the forum!

    Your data will need changing slightly - is this OK?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-19-2017, 05:03 AM #3
    luckyearl
    luckyearl is offline
    Registered User
    Join Date
    01-29-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Get a value based on multiple Criteria Columns

    Thanks Ali

    Changing the data is not a problem..tx
    Last edited by luckyearl; 07-19-2017 at 05:18 AM.
    Reply With QuoteRegister To Reply
  4. 07-20-2017, 05:06 AM #4
    luckyearl
    luckyearl is offline
    Registered User
    Join Date
    01-29-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Get a value based on multiple Criteria Columns

    Hi
    What changes do you suggest to the workbook
    cheers
    Reply With QuoteRegister To Reply
  5. 07-20-2017, 05:13 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Get a value based on multiple Criteria Columns

    This had slipped my mind - sorry. I'll have a look shortly.
    Reply With QuoteRegister To Reply
  6. 07-20-2017, 06:23 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Get a value based on multiple Criteria Columns

    I'm sorry - I've run out of time today. Hopefully someone else will be able to help.
    Reply With QuoteRegister To Reply
  7. 08-05-2017, 02:41 AM #7
    luckyearl
    luckyearl is offline
    Registered User
    Join Date
    01-29-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Get a value based on multiple Criteria Columns

    Hi Ali
    plz have a look at spreadsheet if you have a minute
    thanks
    Reply With QuoteRegister To Reply
  8. 08-05-2017, 03:09 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Get a value based on multiple Criteria Columns

    Sorry - I did and I was not able to find a solution for you.
    Reply With QuoteRegister To Reply
  9. 08-05-2017, 09:48 AM #9
    southward
    southward is offline
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Get a value based on multiple Criteria Columns

    Hi,

    Take a look at the attached spreadsheet.

    I had to modify your lookup table and develop a crazy formula to return the results.

    Give it a critical look and let me know if you need help with it.

    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 08-05-2017, 10:01 AM #10
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Get a value based on multiple Criteria Columns

    Here is another option that also changes the arrangement of the tables on the 'Fitness Rating' Sheet.
    The array entered formula* that populates column G on the 'Main' sheet is:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  11. 08-06-2017, 07:06 PM #11
    luckyearl
    luckyearl is offline
    Registered User
    Join Date
    01-29-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Get a value based on multiple Criteria Columns

    Tx @Southward, you have been kind. been testing it, does throw some errors.

    Thank you @JeteMc, the solution is working flawlessly.

    Great Community !..Cheers
    Reply With QuoteRegister To Reply
  12. 08-06-2017, 08:40 PM #12
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Get a value based on multiple Criteria Columns

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average numbers from multiple columns based on multiple criteria
    By abambi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2015, 01:52 PM
  2. Add Multiple Columns based on same criteria found in multiple columns
    By KathyBNelson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2014, 04:42 PM
  3. Populating fields in multiple cells based on criteria in multiple columns
    By excelalways in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2014, 08:17 AM
  4. formulas for search based on multiple criteria in multiple columns
    By oneworld in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 06:57 AM
  5. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  6. [SOLVED] Deleting Duplicates Based on Multiple Criteria from Multiple Columns
    By Franklic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:31 PM
  7. Macro to Segregate the data based on Multiple Criteria's in Multiple Columns -Challenging!
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2012, 07:31 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1