XLOOKUP Multiple Columns in Excel | XLOOKUP Return Multiple Columns & Rows #shorts

preview_player
Показать описание
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍
In this Microsoft Excel video tutorial I demonstrate how to include multiple columns and rows in your return array.
------------------------
Рекомендации по теме
Комментарии
Автор

this is easy, tell us how to do this when the columns are not in order

arunmm
Автор

Hi, thank you for video! Could you please describe requirements to these both tables? The same headers or column order? Are they both “smart tables”?

marinaplis
Автор

How to get that filtered option sir. Also please post this xlookup for 2016 version. Thanks

mohamedsuhail
Автор

Can the return array be multiple columns away from the look up array ?

imahodler
Автор

how to use index match function please post one video Sir...

vickyrodriguez
Автор

Hi Sir. I was just wondering, i tried this on my excel Home and Business 2019 version and I can't use this kind of formula. What might be the reason? Is this not compatible with the version I'm using?

mckeril