Forum Discussion
An Impossible Problem
Hey guys,
I have no idea if there is a solution for this but what I need is in the workbook.
Thanks in advance.
2 Replies
catherine9910 Looking at your workbook it appears that column B is the column you really want to address and assuming you have that row index column see the attached. I modified your formula in column B to:
=IF(D5<>"",CONCATENATE(D5," ",E5),IFERROR(INDEX(B$4:B4,MATCH(C5-1,C$4:C5)),""))If it's OK to clear "NEXT PAGE" from column D, you can use a formula - see the attached version.
Otherwise, VBA is probably easier.
