I was sent a spreadsheet and have a #NAME? error. I have no idea how to fix this and tried the Excel Help Error button which provides no assistance. The formula is:
=IF(COUNTA(INDEX('Ad Copy Builder'!F:F,A8+1))>0,_xlfn.CONCAT(INDEX('Ad Copy Builder'!B:B,A8+1)," | ",INDEX('Ad Copy Builder'!D:D,A8+1)," | ",INDEX('Ad Copy Builder'!F:F,A8+1)),_xlfn.CONCAT(INDEX('Ad Copy Builder'!B:B,A8+1)," | ",INDEX('Ad Copy Builder'!D:D,A8+1)))
Solved by D. B. in 30 mins