help with lookup and range
 

example data:
a1 b1 c31 d1
e1 f1
S-213A 10/19/2006 60. 10/20/2006 S-213A
S-213A 11/3/2006 66. 1/2/2007 S-200A
S-200A 11/4/2006 69. .
S-200A 12/3/2006 69. .

I need help with formula in f2 that would:
Find S-213A in columnA, then match closest date from D2 with ColumnB, then
return value in column C. So in this case f2=60 and f3=69.
THANKS!

help with lookup and range
 

"Mona" wrote:

example data:
a1 b1 c31 d1 f1
S-213A 10/19/2006 60. 10/20/2006 S-213A
S-213A 11/3/2006 66. 1/2/2007 S-200A
S-200A 11/4/2006 69. .
S-200A 12/3/2006 69. .

I need help with formula in f2 that would:
Find S-213A in columnA, then match closest date from D2 with ColumnB, then
return value in column C. So in this case f2=60 and f3=69.
THANKS!

help with lookup and range
 

sory for my confusion. I corrected what I want. Hopefully this makes sense!

"Mona" wrote:



"Mona" wrote:

example data:
a1 b1 c1 d1 e1 f1
S-213A 10/19/2006 60. 10/20/2006 S-213A
S-213A 11/3/2006 66. 1/2/2007 S-200A
S-200A 11/4/2006 50. .
S-200A 12/3/2006 69. .

I need help with formula in f2 that would:
Find S-213A in columnA, then match closest date from D2 with ColumnB, then
return value in column C. So in this case f2=60 and f3=69.
THANKS!

help with lookup and range
 

See your other post

--
Biff
Microsoft Excel MVP


"Mona" wrote in message
...
sory for my confusion. I corrected what I want. Hopefully this makes
sense!

"Mona" wrote:



"Mona" wrote:

example data:
a1 b1 c1 d1 e1
f1
S-213A 10/19/2006 60. 10/20/2006 S-213A
S-213A 11/3/2006 66. 1/2/2007 S-200A
S-200A 11/4/2006 50. .
S-200A 12/3/2006 69. .

I need help with formula in f2 that would:
Find S-213A in columnA, then match closest date from D2 with ColumnB,
then
return value in column C. So in this case f2=60 and f3=69.
THANKS!