Get the Most expensive Product Name by XLOOKUP

Get the Most expensive Product Name by XLOOKUP

Learn how to dynamically locate and return the name of the most expensive product from a list by utilizing Excel's powerful XLOOKUP function. This instructional video walks you through the process of combining the MAX and XLOOKUP functions to locate the dataset's product name with the highest price. Perfect for Excel users who want to learn smart lookup techniques to improve their data analysis and reporting skills.

Example with Product name and prices

Breakdown of Formula:

=XLOOKUP(MAX($E$2:$E$10), $E$2:$E$10, $D$2:$D$10)

This formula returns the mobile name with the highest price from the given data.

MAX($E$2:$E$10)

• This part finds the maximum value in the Price column (cells E2 to E10).
• In this case, the highest price is 5924 (Samsung).

XLOOKUP(lookup_value, lookup_array, return_array)

• lookup_value: MAX($E$2:$E$10) → 5924
• lookup_array: $E$2:$E$10 → the column containing prices
• return_array: $D$2:$D$10 → the column containing mobile names

XLOOKUP returns the corresponding Mobile Name from the same row in column D after searching for the highest price (5924) in the Price column (E2:E10).

The formula returns "Samsung," the most expensive smartphone brand.

Why Use This Formula:

·       Dynamic: If any price changes in the list, the result updates automatically.

·       Clear: XLOOKUP makes it easy to read and maintain.

·       Efficient: No need for helper columns or complex combinations.

If you enjoyed learning about XLOOKUP WITH MAX, there's so much more waiting for you! Dive deeper into the world of Excel with my eBook “10 Ultimate Excel Lookup Formulas” — your complete guide to mastering powerful lookup functions like VLOOKUP, HLOOKUP, INDEX + MATCH, XLOOKUP, LOOKUP, FILTER, CHOOSE and more.

Whether you're a beginner or an advanced user, this book is packed with real-world examples, practical tips, and easy-to-follow explanations to boost your productivity and confidence in Excel.