+ Reply to Thread
Results 1 to 4 of 4

Auto Populate a field based on two criteria

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    21

    Auto Populate a field based on two criteria

    I am attaching a registration spreadsheet. Currently I use a data validation drop down list to choose the category.
    I am hoping to use the Gender and Age fields to auto-populate the Category field based on which category they fall into.
    For example, if gender is male and age is 22 then the category field would auto-populate "Men - 19 - 29"
    The categories are listed on the Data tab, but for easier reference, they are:
    Men - 18 and Under
    Men - 19 - 29
    Men - 30 - 39
    Men - 40 - 49
    Men - 50 and Over
    Women - 18 and Under
    Women - 19 - 29
    Women - 30 - 39
    Women - 40 - 49
    Women - 50 and Over

    Thanks in advance for your help!
    Attached Files Attached Files

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Auto Populate a field based on two criteria

    Hi marks9172- Paste this in G2 and copy down:

    =INDEX(Data!$A$2:$A$11,MATCH(D2,{0,19,30,40,50})+5*(F2="Female"))

    Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee
    Last edited by leelnich; 08-10-2017 at 03:53 PM.

  3. #3
    Registered User
    Join Date
    04-20-2015
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Auto Populate a field based on two criteria

    Thanks so much! That works perfectly.

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Auto Populate a field based on two criteria

    You're most welcome, thank you for the rep!

+ 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] Auto Populate Cells Based on a Criteria
    By danallamas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2017, 08:06 PM
  2. Auto Populate based on 2 criteria using Array
    By lexusap in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-23-2015, 02:56 AM
  3. Auto Populate Ranges based on Criteria
    By wrasser in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-17-2014, 11:07 PM
  4. VBA auto filter to select field based on certain criteria
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 01:33 PM
  5. Formula to auto populate field based on or statement
    By suromi in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2013, 05:37 PM
  6. Auto-populate field based on drop down box selection
    By nicfarrell in forum Excel General
    Replies: 7
    Last Post: 01-21-2013, 12:47 AM
  7. Auto Populate a list based off of certain criteria
    By finance123 in forum Excel General
    Replies: 3
    Last Post: 03-29-2012, 03:50 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