View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blue Max Blue Max is offline
external usenet poster
 
Posts: 113
Default Problem with MATCH () function . . .

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