I need to find a formula that works as follows: If B2:B6 = Value X and C2:C6 = Value Y, Output is a text value from Range A2:A6.
Since I need it to look in a range on all criteria and output will be a text result from another range, I beleive this needs to be a Vlookup or something similar?
Here’s a concrete example. As you will see, I already developed a formula to find the “Best Time” (I used MINIF). But, let me know if there’s a better way to ID in one formula 1) which driver has the fastest time in each class, and 2) what that fastest time is.
I need to find the value of cell G3. This means, I need to identify the driver’s name (Column A) whose:
- class (Column B) = “P1” AKA cell E3,
- and whose time (Column C) = “20.2” AKA Cell F3