I have a spreadsheet (Sheet1) that consists of 4 Colums:

1) A B C
D
2) Hotel Chain Property Name Check-in Date Discount
3) Hilton San Diego Golf 12/5/2005 $25.00 Off

Then I've created a form on another page (sheet2) to validate discounts.
So If I plug in "Hilton" on Cell A3, "San Diego Golf" on Cell B3, and
"12/5/2005" on Cell C3, My result of course should come out as "$25.00 Off"


I've tried using this formula:

=SUMPRODUCT(--(A3=Sheet1!A3:A38),--(B3=Sheet1!B3:B38),--(C3=Sheet1!C3:C38),Sheet1!D3:D38)

But because Column D is Text it's not reading it.

My Question:

How Can I sumproduct as text