Excel Forum

Excel Magic Trick 306: MCONCAT LOOKUP functions (CAT = 593)

See how to use MCONCAT & LOOKUP functions to lookup values from a table and add results.
Learn about MoreFun (More Functions) add-in.

Also see a formula that use exponents instead of the MCONCAT function to help lookup values from a table and then add the results.

Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions
Excel Magic Trick 302: Randomly Select Names Without Repeats

Mr Excel mrexcel Message Board

Got a Question? Ask it Here in the Forum.