Results 1 to 2 of 2

Return result based of column name

Threaded 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.

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