I try using these three formulas with a UDF code i got from C Pearson on this link http://www.cpearson.com/excel/stringconcatenation.aspx i got these 3 from AlKey, popipipo, protonLeah at this forum and they all work fine when i enter then as a regular formula or array, the problems comes when i tried to use then with the UDF code to concatenate results, when i add StringConcat leading any of these three formulas does not return any value, (cell stay blank) i try to do some changes but then return #VALUE! message

Any help greatly appreciated...thanks in advance...!!


INDEX('Women Rank Placement Record'!AA5:AA185,MATCH(INDEX('Women Rank Placement Record'!C5:C185,MATCH("1st",'Women Rank Placement Record'!F5:F185,0)),'Women Rank Placement Record'!Z5:Z185,0))
=INDEX('Women Rank Placement Record'!Z5:AA185,MATCH(INDEX('Women Rank Placement Record'!C5:C185,MATCH("1st",'Women Rank Placement Record'!F5:F185,0),1),'Women Rank Placement Record'!Z5:Z185,0),2)
=INDEX('Women Rank Placement Record'!AA5:AA185,MATCH(INDEX('Women Rank Placement Record'!C5:C35,MATCH("1st",'Women Rank Placement Record'!F5:F35,0)),'Women Rank Placement Record'!Z5:Z185,"0"))