Index Match Max? - ExcelBanter

Kevin@Radstock Kevin@Radstock is offline

Member

Posts: 93

You will need to post a sample worksheet as the formula doesn't mean much!

Quote:

Originally Posted by Zsoup

I'm working on a pricing tool that uses a single price per user until 30 people. After that it switches to a banded approach. In other words, once you hit 31 people you are charged for 40. So far I have a formula of:

=INDEX($D$36:$AP$41,MATCH(D9,$C$36:$C$41,0),MATCH( E9,$D$35:$AP$35,0))

It works up to 30 but then it bombs out after that. Any advice would be greatly appreciated!

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 06:45 AM.

Menu

About Us