Hello All:
Please help me to split the below long string in multiple lines
IF(ISNA(MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""",(""Will be ""&IFERROR(TEXT(INDEX(Sheet2!$J$1:$J$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),""mm/dd/yyyy""),"""")&"", has been ""&IFERROR(INDEX(Sheet2!$D$1:$D$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""")&"", status is ""&IFERROR(INDEX(Sheet2!$M$1:$M$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""")&"", has been ""&IFERROR(INDEX(Sheet2!$AC$1:$AC$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""")))
Regards,
tt3
Bookmarks