Thread: Match 2 Columns, Return 3rd, Differing Match Types
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Match 2 Columns, Return 3rd, Differing Match Types
One way...

*IF* the data is grouped by color then sorted in ascending order by column
B.
Reply With QuoteReply With Quote