View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WFBJoeB WFBJoeB is offline
external usenet poster
 
Posts: 11
Default return values from an array based on matching text value

I have a 3 column list of data. The first column is a text label (group), the
second is another text value and the third is a value. Using a function
(can't be a macro!!!!!) I want to get back ALL of the second text and third
value rows which match a specified value in the first column. Can this be
done?

Thanks,

joeb