XLOOKUP - Advanced Excel & Google Sheets Reference Formulas

preview_player
Показать описание
XLOOKUP - advanced Excel & Google Sheets formulas with references.

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

I consider myself an expert in Excel and Google Sheet. But always waiting for your videos because you always present something great.

rajteacher
Автор

Sem dúvidas, este e o melhor canal sobre Google Sheets em toda a internet! PARABÉNS!!!

joaopedrobohrer
Автор

This is great! It opens lots of possibilities!

lpanebr
Автор

Did you answer my question on how to rank, break ties, and award the highest rank to the largest weight and the process would continue until it is broken, in Excel and Google Sheets?

JCEurovisionFan
Автор

can you do arrayformula and index-match?

renashbell
Автор

How can get sum range basis on condition in sumifs
If my header match the take range like A:A
Please suggest

vishaldoiphode
Автор

This is amazing, however, it seems to not work the other way around: =SUM(C5:XLOOKUP("TEST", C5:C, D5:D, , 0)) Any suggestions???

moshebiener
Автор

Didnt vlookup also return a reference?

HelenoPaiva
Автор

I just found two limitation on my first try! 🤦 1) The returned reference only works on the same sheet. 2) The returned reference does not work on open ranges, so this does not work: XLOOKUP(B13, A2:A9, B2:B9):B

lpanebr