Index Match Max? - ExcelBanter

Kevin@Radstock Kevin@Radstock is offline

Member

Posts: 93

Hi

It works for me, there are no values 31 - 39 so it will not return anything, except for #N/A.

Quote:

Originally Posted by Zsoup

Attached a sample file. Like I said works for values 1 through 30. But if I enter 31 to 40 I should get the value for 40...

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
Find Exact Match using INDEX, MATCH	DoubleUU	Excel Worksheet Functions	3	August 15th 08 02:42 PM
index(match) Wind Uplift Calculations (match four conditions)	JMeier	Excel Worksheet Functions	8	August 1st 08 01:45 AM
index match array function-returning only first match, need last.	Julie Olsen	Excel Worksheet Functions	3	December 29th 06 12:50 AM
How do I display more than one match in a Index/Match formula?	Trish	Excel Worksheet Functions	0	September 26th 05 10:21 PM
index,match,match on un-sorted data	Brisbane Rob	Excel Worksheet Functions	3	September 24th 05 10:04 PM

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

About Us