Which of the following can you combine with =VLOOKUP to get the largest number in a series based on a set criterion?MaxMinMode

You can combine =VLOOKUP with MAX function to get the largest number in a series based on a set criterion. Here's how you can do it:

1. First, you need to use the MAX function to find the largest number in the series. The syntax for the MAX function is: =MAX(number1, [number2], ...). You can replace number1, number2, ... with the range of cells that contain the series of numbers.

2. After finding the largest number, you can use the VLOOKUP function to find the corresponding criterion. The syntax for the VLOOKUP function is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

   • lookup_value is the value you want to look up, which is the largest number you found using the MAX function.
   • table_array is the range of cells that contains the data.
   • col_index_num is the column number in the range that contains the return value.
   • range_lookup is optional. Use FALSE to find an exact match.

So, the combined formula would look something like this: =VLOOKUP(MAX(range), table_array, col_index_num, FALSE). Replace range, table_array, and col_index_num with the appropriate cell ranges and column number.