Q1 - Yes, it is. You would do so like this:

=MATCH(A2,B1:H1,0)

this would return the relative position of the first exactly matching
value in B1:H1 compared with A2. Note that the zero at the end forces
it to look for an exact match. If A2 is not in the range, then #N/A
will be returned.

Q2 - yes, this would be possible.

However, you need to give some more detail about your data so that a
formula can be offered that is more likely to suit your set up
directly.

Hope this helps.

Pete

On Dec 11, 1:13*am, "Blue Max" wrote:
FIRST, is it possible to use the MATCH () function on an unsorted range of
data? *We just need a match from the range, regardless of whether it is the
first, last, or inbetween match. *In turn, this match echos the column
heading label associated with that amount using an INDEX () function.

SECOND, is it possible to return all the matches in an unsorted series, grab
their associated column headings, and then concatenate them into one string?

Any help would be appreciated . . .