Results 1 to 5 of 5

How to find value in another table and return value from same row

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    Isle of Wight
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to find value in another table and return value from same row

    Hi all

    This is my first post here so apolgies if I'm using the wrong sub-forum or anything like that.

    I really need some help with the following problem in Excel 2010.

    I have two vaery large tables of data:

    Table 1 is a long list of unique items in no particular order, each of which belongs to a unique group of items, for example:

    Items Group ID
    apple
    pear
    grape
    fig
    banana
    guava
    peach
    mango

    Table 2 lists all the Group ID numbers and in the same row as each Group ID number, shows the names of all the items belonging to that group, one item in each column. Different Groups have different numbers of items in them. For example:

    Group ID Item1 Item2 Item3 etc.
    214 apple pear grape
    33 fig
    7 banana guava
    59 peach mango

    Is there a formula I can use in the second column of Table 1 to look for each item in Table 2 and tell me what group it is in? For example for "apple" or "pear" or "grape" it would look in Table 2 and return the Group ID number "214".

    Hope I've explained that clearly and thanks in advance for any ideas.
    Last edited by jpearson01; 12-14-2012 at 01:50 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1