Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...

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.