To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...
Windows Report on MSN
Microsoft Excel can now store multiple values in one cell
Microsoft Excel now supports multiple values, Lists, nested arrays, and new array functions inside a single cell for Insider users.
Select a cell and use Insert > List or press Ctrl+J to create a list.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results