help with lookup and range

M

Mona

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

Mona

Mona said:
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!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank and Sort 2
Help with lots of formulas 3
Lookup and average data in an unsorted list 1
column to row draging 1
Index Match Help 6
Need help extracting date and time with Excel 2K 11
Formula to Create Consecutive #s for Non-Linear Dates 3
How to use VLookup with a range of numbers? 3

Top