vlookup from multiple columns with only one return

How to Perform a VLOOKUP With Multiple Lookup Values in Same Column

In order to perform a VLOOKUP with multiple lookup values in the same column, you must alter the array in…