Results 1 to 4 of 4

Multiple Values returned in a lookup

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2013
    Location
    Alabama
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiple Values returned in a lookup

    I have a table where the rows are conditions and the columns are experiment numbers, as an example below:

    Experiment 1 Experiment 2 Experiment 3
    Hardness X X
    Solubility X X
    Density X X


    The table is fairly large. What I would like to be able to do is use a lookup/formula that will return all the experiment numbers a given condition is tested in. In other words, for a given condition (i.e., Hardness), which columns have an "X". Not sure if that can be done with a lookup or not or if there is another function necessary. I would like to be able to do it without macros though and also have it automatically update if I move the "X" around to different experiments.
    Last edited by Droopy23; 12-23-2013 at 01:03 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using approximate lookup and getting duplicate returned values
    By nikkigotro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2013, 02:54 PM
  2. Duplicate values returned using Index Match Lookup with Small()
    By jacob@thepenpoint in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2013, 10:48 AM
  3. Replies: 4
    Last Post: 04-20-2012, 06:17 AM
  4. Lookup row for value and sum returned values.
    By TypeR in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-11-2007, 07:16 AM
  5. Can I get multiple values returned for an IF formula?
    By TeachCTC in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-15-2005, 10:55 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