Excel 2016 - 3.7.9 - Create an Array LOOKUP

An Array LOOKUP is also rarely used these days. It can take a table as its selection, but can only ever return a result from the last column of the table, whatever that might be. But just in case you need to know it…