Results 1 to 8 of 8

Formula for matching a column in excel to two other columns

Threaded View

  1. 03-09-2017, 01:38 AM #1
    hmoayyed
    hmoayyed is offline
    Registered User
    Join Date
    03-09-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Formula for matching a column in excel to two other columns

    In an excel sheet I have three columns.

    Column A includes first names of people in a survey, Column B includes the most popular male names, column C includes the most popular female names.

    I want to see whether the names in column A are male, female, or unknown (based on Column B and C)?

    Also, If a name in column A is for example "James 31" and in column B "James" exists, I want the excel to count "James 31" as "male" and not unknown!

    Thank you in advance!
    Attached Files Attached Files
    Last edited by hmoayyed; 03-09-2017 at 01:59 AM.
    Reply With QuoteRegister To Reply
« 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. matching value of 2 columns in sh1 & sh2 then get value of 3rd column
    By tuongtu3 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-25-2013, 01:39 AM
  2. Excel Formula to find matching row based on multiple columns
    By joshhazel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2013, 01:53 PM
  3. Lookup matching txt in one column then sum same row in three other columns
    By des333 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 07:34 AM
  4. Matching and printing values from two excel columns in another column on certain condition
    By meetvivek72 in forum Excel General
    Replies: 5
    Last Post: 08-24-2012, 10:59 AM
  5. [SOLVED] Excel 2007 : Return all values from a column, based on matching conditions in other columns
    By Alyena in forum Excel General
    Replies: 3
    Last Post: 11-24-2011, 09:55 AM
  6. Sorting columns to remove blanks on 1 column, matching with other columns
    By macca345 in forum Excel General
    Replies: 3
    Last Post: 06-09-2011, 05:58 AM
  7. How to get the matching value from two columns and put it to another column?
    By jqcabanban in forum Excel General
    Replies: 4
    Last Post: 04-18-2010, 04:50 PM
  8. matching columns to produce new column
    By cls1 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-04-2008, 05:54 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