How to use a nested XLOOKUP within an XLOOKUP

preview_player
Показать описание
Ever wished you could do a two-dimensional or multi-criteria XLOOKUP? YOU CAN! In this short I show you how to use a nested XLOOKUP within an XLOOKUP to allow for multiple inputs driving a single output.

Some might think "why not just use INDEX/MATCH/MATCH?", and it's a valid question because effectively you're doing a similar operation here, but the syntax of the XLOOKUP is just a lot more user friendly.

Check it out and let me know what you think in the comments!

#excel #exceltips #xlookup #indexmatch #nestedformula
Рекомендации по теме
Комментарии
Автор

🤯Instead of doing an index and match! So much faster!

cbabe
Автор

Hi Matt, I don't find xfunction in 365 excel

hariskhan
Автор

This might be a stupid question but how did you get the drop-down menu in excel?

ericlu
Автор

I didn't see this xfunction in new 365

hariskhan