This video exhibits an example of the XLOOKUP Function in excel with Multiple Criteria. In this example we have a data set that contains different workout types, workout intensity, body weight ranges and calories burned based on different combinations on the type, intensity and body weight ranges. The objective is to pull back the calories burned based on the different the type, intensity and body weight ranges. This can be easily done by joining search values and criteria ranges together via the XLOOKUP Function.
Learn More about Excel VBA & Macros with this Book on Amazon:
[ Ссылка ]
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
[ Ссылка ]
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
To get a copy of the file used in this workbook click the link below and look for the file name "XLookup Multiple Criteria."
[ Ссылка ]
