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).
Bookmarks