Return a value from Chart 1 depending on the value typed into char
 

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!!

Return a value from Chart 1 depending on the value typed into char
 

Try vlookup assuming the 1st chart data is arraned in Sheet1 A:B...From
sheet2 cell B1 try the below with A1 having the date
=VLOOKUP(A1,Sheet1!A:B,2,0)

'Error handled
=IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,0)),"",VLOOKUP(A1 ,Sheet1!A:B,2,0))

If this post helps click Yes
---------------
Jacob Skaria


"Folletti" wrote:

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!!