Multiple Criteria LOOKUP (VLOOKUP, XLOOKUP) in Excel & Google Sheets, Multiple Matches Supported

No video

Multiple Criteria LOOKUP (VLOOKUP, XLOOKUP) in Excel & Google Sheets, Multiple Matches Supported

Рет қаралды 11,252

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 24

@xjarius 2 жыл бұрын

Absolutely love these videos. Thank you!!!

@ExcelGoogleSheets 2 жыл бұрын

Thank You!

@garychadwick1240 2 жыл бұрын

I wish even one of my teachers back in my schooldays had had your level of imparting complicated knowledge in such a well explained fashion. Thank you once again.

@ExcelGoogleSheets 2 жыл бұрын

Wow, thank you!

@ExcelAZ 2 жыл бұрын

Interesting! Filter and N combination in Google sheet 💝.

@nurserytoys 2 жыл бұрын

#Excellent #Excellent #Excellent _Sir Your Explanation is Awesome_ *_i am Your GoogleSheet Admirer(Fan) , More Than 4 years ago_* *LoveYouSir*

@nurserytoys 2 жыл бұрын

in my old mobile phone.

@ExcelGoogleSheets 2 жыл бұрын

👍

@Dexcelo 2 жыл бұрын

Thank you very much for the great explanation !!

@ExcelGoogleSheets 2 жыл бұрын

Thanks for watching!

@eduardorivera4720 2 жыл бұрын

Me encantan estos videos aprendo bastante, aunque la barrera de entrada sea el lenguaje, me gustaría que estos videos tuvieran subtitulos en español para que pudiera llegar a más usuarios, ya que en lo particular entiendo únicamente viendo, pero no estaría de mas leerlo ya que siempre puede que haya algo que no percibimos.

@vishaldoiphode07 2 жыл бұрын

❤Thank you so much, You are pro.i learnt many things from you

@ExcelGoogleSheets 2 жыл бұрын

Thank You!

@hamvasq Жыл бұрын

Thanks!

@ExcelGoogleSheets Жыл бұрын

👍

@motogoa 2 жыл бұрын

Very neat method, thanks!

@ExcelGoogleSheets 2 жыл бұрын

👍

@paulhitchman2312 2 жыл бұрын

This is cool but I think it works in Sheets without the N and N* function... just use (,) and keep adding logical tests. Anyway thanks this was very very helpful with the spill function for duplicates. Just what I was looking for.

@ExcelGoogleSheets 2 жыл бұрын

Correct, but I like my spreadsheets compatible for both if possible.

@Allen-L-Canada 2 жыл бұрын

multiple condition very useful! Also N() is new to me.

@ExcelGoogleSheets 2 жыл бұрын

👍

@richardhay645 2 жыл бұрын

your title said you would do it with XLOOKUP!!. Also it is unhelpful to do Sheets, Exce. for windows, Excel for Mac and Excel OnLine in one video. PICK A LANE at least for a single video. BTW: N functions; SERIOUSLY? As an Excel desktop 365 user I NEVER use N functions. Make it clear to your viewers that Microsoft created N functions only for compatibility with other programs.

@ExcelGoogleSheets 2 жыл бұрын

The point is that you wouldn't use XLOOKUP or VLOOKUP, that's what people think they should use. Also N function rocks. It serves as a great wrapper function instead of just using bunch of nested parenthesis that make things confusing. Doesn't really make any difference why Microsoft created it. It's a quick and reliable way to convert true/false to 1/0.

@richardhay645 2 жыл бұрын

@@ExcelGoogleSheets title TOTALLY deceptive regardless of their efficacy. FILTER handles TRUE/FALSE just fine on its own. I use FILTER regularly and often as a lookup function and never have needed an N function to improve efficiency.