Columns A & B contain two lists of numbers.
We want to create a formula that will return the maximum value from either list, providing that the following two conditions are satisfied:
Numbers from List1 must be larger than 3.
Numbers from List2 must be larger than 20.
If the maximum value found does not meet the above criteria, the formula should look for the next largest number until finding the largest number matching criteria.
Use the MAX functions in the following Array Formula:
Screenshot // Finding the Largest Value from Two Different Lists, Subject to Specified Criteria