How To: Use the MCONCAT function in Microsoft Excel

Use the MCONCAT function in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.

Get the Gadget Hacks Daily

Our latest smartphone hacks — straight to your inbox.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest