Excel Forum

Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution

See how to take transaction records with rows of numbers, math a single criteria, then lookup a row of commission rates and multiply all the rows from the transactional data set by the row of commission rates.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.