Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array or range lookup per row? | Excel Worksheet Functions | |||
Lookup in a range. | Excel Discussion (Misc queries) | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup | Excel Discussion (Misc queries) |