vlookup with multiple criteria in different columns

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…