Posted to microsoft.public.excel.worksheet.functions

Mona

external usenet poster

Posts: 69

index and match closest

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to index the closest data(cash flow)?	[email protected]	Excel Worksheet Functions	5	June 12th 07 08:34 PM
Text comparison - closest match	pappu	Excel Discussion (Misc queries)	5	July 6th 06 10:41 AM
closest match	[email protected]	Excel Worksheet Functions	4	June 11th 06 02:30 PM
Finding Closest Match	andyiain	Excel Worksheet Functions	1	March 15th 06 07:24 PM
Closest number match help ...	NP	Excel Worksheet Functions	0	October 28th 04 09:33 AM

All times are GMT +1. The time now is 07:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us