I'm looking to bring back a specific value that i have in a chart, depending
on the value that is typed in. I know,confusing. Basically, i already have
a chart made with a list of values based on dates. I want to be able to type
a date in another chart, and have the value that was based on that date from
the first chart appear. Example:

Chart 1
Column A Column B
10/1/09 =WORKDAY(B1372,4,$Q$1363:$Q$1377)

10/2/09 =WORKDAY(B1372,4,$Q$1363:$Q$1377)
10/3/09 =WORKDAY(B1347,5,$Q$1363:$Q$1377)

Chart 2
I will place a date in column A. I'd like that date to bring back the value
from column B in Chart 1.

Column 1 Column B
10/3/09 ??? (I want this:=WORKDAY(B1347,5,$Q$1363:$Q$1377))

Of course, I'd like the value to be returned to Chart 2, not the formula.
But I put the formula in so you'd know what I'm working with.

Thanks for any help you can give me!!