Hi,
I have the following formula, but would like the Database!$L$1054:$L$16053 part replaced with "Complete" if a match is found
=IFERROR(INDEX($P$11:$P$35,SMALL(IF($Q$11:$Q$35>0,ROW($Q$11:$Q$35)-ROW($Q$11)+1),ROWS($J$11:$J11))),IFERROR(INDEX(Database!$L$1054:$L$16053,MATCH(C11,Database!$C$1054:$C$16053,0)),IFERROR(INDEX(Database!$L$1054:$L$16053,MATCH(C11,Database!$C$1054:$C$16053,0)),"")))
Any help would be greatly appreciated
I have the following formula, but would like the Database!$L$1054:$L$16053 part replaced with "Complete" if a match is found
=IFERROR(INDEX($P$11:$P$35,SMALL(IF($Q$11:$Q$35>0,ROW($Q$11:$Q$35)-ROW($Q$11)+1),ROWS($J$11:$J11))),IFERROR(INDEX(Database!$L$1054:$L$16053,MATCH(C11,Database!$C$1054:$C$16053,0)),IFERROR(INDEX(Database!$L$1054:$L$16053,MATCH(C11,Database!$C$1054:$C$16053,0)),"")))
Any help would be greatly appreciated