XLOOKUP - Advanced Excel & Google Sheets Reference Formulas

No video

XLOOKUP - Advanced Excel & Google Sheets Reference Formulas

Рет қаралды 15,263

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

XLOOKUP - advanced Excel & Google Sheets formulas with references.
Learn XLOOKUP fundamentals • XLOOKUP - Excel & Goog...
#excel #formula

Пікірлер: 31

@rajteacher Жыл бұрын

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

@ExcelGoogleSheets Жыл бұрын

👍

@joaopedrobohrer6241 Жыл бұрын

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

@sabaripandian116 Жыл бұрын

You are great, simple yet effective

@ExcelGoogleSheets Жыл бұрын

Thanks!

@cheskavillanueva5772 Жыл бұрын

Excellent as always!

@ExcelGoogleSheets Жыл бұрын

Thank you!

@lpanebr Жыл бұрын

This is great! It opens lots of possibilities!

@ExcelGoogleSheets Жыл бұрын

Did you check out the MAP video? That should take care of your array problems.

@lpanebr Жыл бұрын

@@ExcelGoogleSheets yes, I did! I was writing a comment but had to stop and forgot. It definitely solves the arrayformula. I used it today. It's orders of magnitude better than array formula! Thanks! I'm also always waiting for your videos.

@LotfyKozman Жыл бұрын

@@ExcelGoogleSheets Lambda helper functions didn't take much care from your side!

@ExcelGoogleSheets Жыл бұрын

@@LotfyKozman I'm not sure what you mean. I covered these months ago, very few people watched them.

@vishaldoiphode07 Жыл бұрын

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

@ExcelGoogleSheets Жыл бұрын

Why do you have to use the whole column? Just start from A2.

@vishaldoiphode07 Жыл бұрын

@@ExcelGoogleSheets my question not related to this video I want sum range in sum ifs Example- If I have dates in rows city names in columns Rest value is in any number I want to sum numbers on dates criteria & sum range should be matching by headers

@JCEurovisionFan1996 Жыл бұрын

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?

@ExcelGoogleSheets Жыл бұрын

I don't really understand what you're trying to do.

@bzmin99 Жыл бұрын

Another bomb ass video!! Thank you

@renashbell4317 Жыл бұрын

can you do arrayformula and index-match?

@ExcelGoogleSheets Жыл бұрын

yes. kzfaq.info/get/bejne/gJeTYLFo1NPPiJs.html

@moshebiener4507 Жыл бұрын

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

@ExcelGoogleSheets Жыл бұрын

works fine for me. your XLOOKUP must not be finding a match.

@HelenoPaiva Жыл бұрын

Didnt vlookup also return a reference?

@ExcelGoogleSheets Жыл бұрын

Yes

@lpanebr Жыл бұрын

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

@ExcelGoogleSheets Жыл бұрын

this worked for me, even though I have fewer rows =SUM(XLOOKUP(B13,A2:A9,B2:B9):B1000000)

@ExcelGoogleSheets Жыл бұрын

this works for me as well from different sheet, LOOKUP being the sheet name =XLOOKUP(LOOKUP!B13,LOOKUP!A2:A9,LOOKUP!B2:B9):LOOKUP!B100

@ExcelGoogleSheets Жыл бұрын

Haven't tried these 2 in Excel.

@lpanebr Жыл бұрын

@@ExcelGoogleSheets you'd right about different sheets. I was doing it wrong. But the open ended range really doesn't work. Here's an example: docs.google.com/spreadsheets/d/1iDITuNZ2YiSEzhpwCYshnvmmGHc9yrigbjK_NpccVsA/edit?usp=drivesdk on sheet2

@ExcelGoogleSheets Жыл бұрын

I didn't say it does, but you can go around it but simply using a very large number, like B1000000