EXCEL: Most Clever Lookup Formula with Multiple Conditions

I came across an excel lookup function through the following link.  https://www.extendoffice.com/documents/excel/2440-excel-vlookup-multiple-criteria.html

Then I found further explanation in the following forum.

https://www.excelforum.com/excel-formulas-and-functions/1043140-explain-lookup-2-1-a2-a10-d2-b2-b10.html

The structure for the formula is:

=LOOKUP(2, 1/(COLUMN1=CONDITION1)/(COLUMN2=CONDITION2)/(COLUMN=CONDITIONn), (RESULTCOLUMN))

This formula can be used to look up both numeric value and character value that match multiple conditions.  COLUMN1=CONDITION1 will produce an array of 0s and 1s; 1 divided by the array will produce an array of %Div/0s and 1s; then the array will be further divided by an array of 0s and 1s (results of column2=condition2) and so on.  The lookup value is set at 2 because 2 is greater than 1, and if lookup_value (2) is not found within the lookup_vector, LOOKUP returns the last value in that array which is less than 2.  The formula then returns the value in the result column using the corresponding position found in the lookup columns.