Formula for returning date entered by date on another worksheet
 

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.

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

Formula for returning date entered by date on another worksheet
 

Just some thoughts. "Date/s" require extra care in matching as any formatting
applied may disguise the underlying value. For example: "May 2008" which
shows in a cell may actually house the date: 1-May-2008 with the cell
formatted to display as: mmm yyyy. Or it may actually house the text: May
2008 (entered with a preceding apostrophe). Both data won't match with each
other.

if the value for May 2008 is 87.5% on the table in worksheet 1,
Assume the "May 2008" above is in A2, in Sheet1

when I enter the May 2008 in a table on worksheet 2
Assume the "May 2008" above is in C2, in Sheet2

Do this test in any empty cell in Sheet2: =C2=Sheet1!A2
What do you get? If both match, it should read TRUE

Assuming the lookup col contains text labels: May 2008
while the lookup values are actually real dates (formatted),
you can make the lookup values consistent for matching with the text labels
via using TEXT, something like this:
=VLOOKUP(TEXT(A1,"mmm yyyy"),Sheet1!A:B,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---