Results 1 to 3 of 3

INDEX MATCH a table of X's pulled from another sheet.

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    68

    INDEX MATCH a table of X's pulled from another sheet.

    I'm trying to show a table of X's populated from a different sheet.

    On sheet2 I have raw data that is fed from multiple sheets. It shows what degrees people hold.

    On Sheet1 I would like to have a table of X's that finds the information in Sheet2.

    So the name in A2 would match itself to B1 and find if it matches to the raw data in Sheet2. If it finds it, an X is placed in the table.

    How would I go about creating a formula to find this for the whole table? I've attached an example sheet to make better sense of it.

    Positive rep to all that help. Thanks!
    Attached Files Attached Files
    Last edited by purdue7997; 12-30-2013 at 10:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create VLOOKUP or INDEX/MATCH to copy values from Sheet 2 to Sheet 1
    By leog1969 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-03-2013, 05:58 PM
  2. Table amending by overwriting table?? what formula index/match
    By Tradesman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 02:24 PM
  3. [SOLVED] Index , match , table value look up,
    By The Learner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2012, 03:21 AM
  4. Index, Match in table
    By Georgia Golfer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2009, 04:49 PM
  5. Using AutoFilter to Sort Data Pulled in by INDEX / MATCH
    By A Romeo Jr in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2006, 07: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