Thread: sumproduct??
View Single Post
 
Old 10-14-2012, 08:33 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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
Reply With Quote