Multiple criteria XLOOKUP - Excel 365 Tutorial
Use multiple criteria in your XLOOKUP to find a specific result in a data set that contains this item more than once, but with distinctions between those occurrences. (For example, more than one Bob Smith in the list, but they work in different departments.)
Timecodes:
0:00 - Intro
0:39 - Lookup_value
0:49 - Multi-criteria Lookup_array
1:29 - Return_array
1:43 - Excel 365 Spill functionality
2:29 - Explanation of why 1 is used for Lookup_value
Visit our business homepage: https://mycostpro.com
Watch video Multiple criteria XLOOKUP - Excel 365 Tutorial online without registration, duration hours minute second in high quality. This video was added by user Excel 101 24 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 110 once and liked it 7 people.