|
|
#2
10-12-2012, 11:47 AM
|
||||
|
||||
If you re-arrange your From-To charge table slightly you can use an approximate match to find the correct charge. Have a look at Example 1 here:
http://colinlegg.wordpress.com/2012/...-with-vlookup/ That example looks up grades by percentage, but it's the same principle. The only reason to use SUMPRODUCT (or equivalent) would be if you want to calculate multiple charges and sum them in one go. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sumproduct formula
|
Portucale | Excel | 2 | 09-12-2012 10:51 AM |
| Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
|
Sumproduct
|
angie.chang | Excel | 3 | 06-14-2012 10:00 AM |
|
sumproduct formula to pull info from multiple sheets
|
Berk21 | Excel | 7 | 01-15-2012 11:41 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode