put in text like so.
![]()
=TEXT(IF(ROWS(E$4:E4)>$C$1,"",INDEX(INDEX(Overview!$A:$AZ,0,MATCH(E$3,Overview!$1:$1,0)),MATCH("Yes-"&ROWS(E$4:E4),Overview!$AA:$AA,0))&""),"$#,##0.00")
put in text like so.
![]()
=TEXT(IF(ROWS(E$4:E4)>$C$1,"",INDEX(INDEX(Overview!$A:$AZ,0,MATCH(E$3,Overview!$1:$1,0)),MATCH("Yes-"&ROWS(E$4:E4),Overview!$AA:$AA,0))&""),"$#,##0.00")
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks