Posted to microsoft.public.excel.worksheet.functions

Iriemon

external usenet poster

Posts: 89

Index & Match Question

One last question:

How would this be modified to find the closest or next smaller value?

=INDEX('Sheet2'!$BH$2:$BH$94,MATCH(O2&T2,'Sheet2'! $BF$2:$BF$94&'Sheet2'!$BG$2:$BG$94,0))

For example, if I am trying to match .625 and 5000 and the table has:

..625 4000 .55
..625 4750 .65
..625 5500 .25
..625 6000 .35

How do I get it to return the .65?

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
Index / Match Question	carl	Excel Worksheet Functions	1	December 24th 08 02:16 PM
Index match question	SGT Buckeye	Excel Discussion (Misc queries)	6	May 30th 07 06:13 PM
Index/match question.	Jules	Excel Discussion (Misc queries)	1	July 8th 06 04:03 PM
Index/match question.	Jules	Excel Worksheet Functions	0	July 6th 06 06:49 PM
Match or Index Question	carl	Excel Worksheet Functions	2	October 4th 05 09:11 PM

All times are GMT +1. The time now is 11:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us