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.
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)),""))