vlookup from multiple columns with only one return

Using VLOOKUP With Range Criteria

If you have data in a table, you can use the VLOOKUP function to find the value in a specific…