Lookup and return multiple values in one cell | Simple Trick | Learn In 5 Minutes
In this video, we will see how we can combine simple formulas to lookup and return multiple values duly separated with comma in a single cell in Microsoft Excel. Moreover to achieve this task we will not be using any of the lookup function we'll use simple functions like if, textjoin and unique which are available in latest version of Microsoft Excel How to get Microsoft Office 365 Legally for free: • How to get Microsoft Office 365 Legally fo... Chapters 00:00 Intro 01:10 Application of Unique Function 01:30 Application of If Function 02:20 Application of Textjoin function 03:13 Application of Unique & Sort Function 04:12 Closure