View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Concatenate with differents conditions

I've posted one crack at it in your latest re-post
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"JMALTO" wrote:
Thanks for your respond.
For instant, in H1 I have "24", then every time that finds a match in column
"F or G" and "IF" column "B" the corresponding row value is "1", then I pull
the corresponding data from column "A".
The answer for that, will be

I 1 =Match(H1 within F or G columns AND IF B column =1, A1:A7)