Excel Forum



Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add


See how to use the SUMPRODUCT, INDEX and MATCH functions to Lookup All Values In Expanding Dynamic Row and then Add. See how to use a zero (0) in the INDEX Function row or column argument to lookup a whole column.

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





Got a Question? Ask it Here in the Forum.