You can do this by nesting a MATCH() function inside a VLOOKUP()
function. Start the VLOOKUP using the the first criterion, then
instead of entering a column number in the VLOOKUP use the MATCH()
function to return a column number. However, since your first
criterion occupies column 1 of the array, your MATCH function needs to
be incremented by 1 to adjust for it.