Excel 2007 : Return a value from another worksheet

[NMJones]

EXCEL 2007 -in the same workbook but on a different worksheet I want to return a value - example if column A = RVDB and column B = 2/1/2010 - I want the fomula to return the value of the cell 5.33

Example
Worksheet name TGT
Column A - Org
Column B - Date
Column C - Target

A B C
1 RVDB 1/1/2010 4.55
2 RVDB 2/1/2010 5.33
3 RVJJ 1/1/2010 4.22
4 RVJJ 2/1/2010 3.39

[NBVC]

Try:

=SUMPRODUCT(--(TGT!$A$1:$A$100=A1),--(TGT!$B$1:$B$100=B1),$C$1:$C$100)

adjust ranges to suit, but don't use whole column references and keep to a mimimum, then copy down

Where A1 and B1 contain the lookup values to find in sheet TGT range A1:A100 and B1:B100