+ Reply to Thread
Results 1 to 2 of 2

Return result based of column name

Hybrid View

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    16

    Return result based of column name

    I will use an example to describe my problem:

    Example: 4 different groups (A,B,C,D). The groups are placed in raw 1. The order of the groups are unknown (i dont know in which column each group is placed). Each group has more than 1 number attracted to it.

    1A = Group A. 1B = Group B. 1C = Group C. 1d = Group D. 1E = Group D. 1F = Group B. 1G = Group a. 1H = Group C.

    Cells 2A:2H are filled with unknown numbers that I need to find.

    In cell 3A I have the formula: Hlookup("Group A,1A:2D,2,0).
    Is there anyway I can the following formula in cell 3B: Hlookup (Group A, 1E:2H,2,0).
    Attached Images Attached Images
    Last edited by MathiasH; 10-08-2011 at 04:23 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Return result based of column name

    An example workbook would be much better than an image!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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