Can Not Return Text From a Sum Array Type Formula

I understand how to use array formulas in a SUM situation but do not know how to pull/return text with an array. In the attached example I, pretty much, want the formula to say (column E) if Joe Schmoe spent $1.00 on 1/1/2012 on which ER number was that charge?

I would like to try: {=SUM((Data!$A$2:$A$10)*(A2=Data!$A$2:$A$10)*(B2=Data!$C$2:$C$10)*(D2=Data!$E$2:$E$10))} but i know that will not work because Data!$A$2:$A$10 is text so I know it will not SUM.

Per your example, E2 is:
=LOOKUP(2,1/((Data!$A$2:$A$10=A2)*(Data!$C$2:$C$10=B2)*(Data!$D$2:$D$10=C2)*(Data!$E$2:$E$10=D2)),Data!$B$2:$B$10)
and copy down.

Per the FAQ link at the top of the page:

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save