Formula for returning date entered by date on another worksheet
On Jan 28, 9:41*pm, Tom wrote:
I am *obviously fairly new to this, but here is my question:
I have created a simple table on one worksheet where I enter monthly
results, and would like those numbers to display on other worksheets in the
same workbook when I enter the correspnding date in another table.
For example, if the value for May 2008 is 87.5% on the table in worksheet 1,
when I enter the May 2008 in a table on worksheet 2 ,I would like the 87.5%
to return there as well.
I am probably making this sound more *complicated than it really is, but any
help would be greatly appreciated.
Will be a lookup funstion
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)
A1 = A1 Sheet2
|