Converting Text to Currency

This formula was provided to me by daddylonglegs (thank you!). However, it returns a text reference. How would it be amended to return a currency?

=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))&"")

Attached is my sample worksheet. This formula is on the Event Flyer worksheet cell E4. I would like it to return $750.00 and not 750. I've tried every which way but the correct way, and I'm crying "uncle." Thank you for your help.

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