Learn How To Use XLOOKUP With Multiple Criteria in Excel - Excel Dose

preview_player
Показать описание
Dear Subscriber,

In this video you will learn how to use XLOOKUP with multiple criteria. We have explained the two methods to use XLOOKUP.

***************************
Рекомендации по теме
Комментарии
Автор

Great video 👍🏻😊very helpful . Didn't know about xlookup...will try this...

AapkaApnaTastyTadka
Автор

Just for information, the first approach takes a long time for the spreadsheet to calculate if you have a large dataset (in my case, two columns, 400 rows took about two minutes to calculate on a 2 GHz Dual-Core Intel Core i7 processor). Have not tested the second approach.

kdcarver
Автор

Great video, any pros and cons of eacj method? When should either or be used or not used?

raakhishah