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
Bookmarks