Hi All,

I have been using Index Match formulas for a while, but this one instance
has me stumped.

Instead of an array of elements I have a matrix, and the Match function does
not work.

Here is how my data is in the source sheet:


Row 1: Label1 Label2 Label3
Row 2: A B C
Row 3: D E
Row 4: F G


In another summary sheet I have

Cloumn1 Column 2
A Need function to return Label1
B Need function to return Label2
C Need function to return Label3
D Need function to return Label1
E Need function to return Label2
F Need function to return Label1
G Need function to return Label2


Is it possible to use Vlookup for the function I need in Column 2?
I need a function to search through the matrix and return the label above
the found value.
Thanks in advance!
Stan