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...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.