|
|
#7
10-14-2012, 08:33 AM
|
||||
|
||||
You don't need the "To" column, so delete it in your example file. Then you can use either of these formulas:
=VLOOKUP(A9,A2:B6,2)*A9 =LOOKUP(A9,A2:A6,B2:B6)*A9 
|
|
|
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