XLOOKUP - Excel & Google Sheets, XLOOKUP function from Other Worksheets, Join/Merge Data

No video

XLOOKUP - Excel & Google Sheets, XLOOKUP function from Other Worksheets, Join/Merge Data

Рет қаралды 31,090

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 53

@TilakConrad Жыл бұрын

you have a really superb style of presentation - thank you very much 🙏

@ExcelGoogleSheets Жыл бұрын

Thank you!

@shuaibchowdhary4015 Жыл бұрын

Excellent video, learned more in one video than a hundred others, especially using x look up when searching data fRom two separate tables and sheets, as well as array return ranges, and all of the other item. Perhaps you can show how to use x look up in place of index match

@netboy1102 Жыл бұрын

Good to hear about the availability of xlookup in Google sheets. Still need to wait for it appears in my sheets.

@dirknoom4389 Жыл бұрын

excellent video, also appreciate there's no background music so I can add my own :)

@NSE_Foden Жыл бұрын

Thanks, that was well presented and very easy to follow.

@ExcelGoogleSheets Жыл бұрын

Thank You!

@bzmin99 Жыл бұрын

I've been waiting on this day since forever!!! God I'm so happy

@ExcelGoogleSheets Жыл бұрын

At least someone is :)

@timetriad6199 Жыл бұрын

Quality work and easy to follow. 👍🏻 Can xlookup return values from a range of Sheets? If so, is this something you’ve covered already? Thanks

@austenausten1266 8 ай бұрын

Great,easy to understand

@rajeshr8887 Жыл бұрын

Awesome! I’m assuming the look up can be a date as well, will try it out.

@ExcelGoogleSheets Жыл бұрын

Yes, can be dates.

@tanjilahmed95 Жыл бұрын

Thank you for show difference between excel and Google sheet

@ExcelGoogleSheets Жыл бұрын

👍

@hemantsonawane153 Жыл бұрын

Thanks a lot.. i was waiting for this video..

@ExcelGoogleSheets Жыл бұрын

👍

@mohdrayees8919 Ай бұрын

Great

@droven101 Жыл бұрын

Thanks again for the great content!

@ExcelGoogleSheets Жыл бұрын

👍

@aviadbenhamo5812 Жыл бұрын

Thanks for an excellent video. Now that xlookup is supported in google sheet is there any advantage using vlookup? Or from now I should use xlookup only?

@ExcelGoogleSheets Жыл бұрын

Well, it's a difficult question to answer. VLOOKUP could be better if you want to work with one range instead of 2 ranges. You might also want to make sure your spreadsheets are compatible with older Excel versions in certain cases if you're emailing files to clients. Since you're asking this questions, I would say just use xlookup.

@jpbolle Жыл бұрын

Good vidéo as usual… I have a question: is it possible with xlookup to return multiple columns when you add an arrayformula ?

@ExcelGoogleSheets Жыл бұрын

No, it doesn't work. Use VLOOKUP instead.

@jdml3575 Жыл бұрын

Great vid! Really appreciate it

@ExcelGoogleSheets Жыл бұрын

👍

@shannonlee9999 Жыл бұрын

This is great. I cannot get this to work in Google Sheets using 2 different sheets. Your example only shows using tabs within the same sheet. Do you know how to get it to work with 2 sheets?

@ExcelGoogleSheets Жыл бұрын

Sure. Use IMPORTRANGE function. kzfaq.info/get/bejne/Zt99grCEp6uykqM.html

@vishaldoiphode07 Жыл бұрын

Thank you so much❤

@ExcelGoogleSheets Жыл бұрын

👍

@miyagenco.ltd.3100 Жыл бұрын

IT helpful, thank you

@ExcelGoogleSheets Жыл бұрын

👍

@sahraj78 Жыл бұрын

Sir pl, please suggest which Antivirus is best for Laptops

@Simba.Luna. Жыл бұрын

What is the keyboard shortcut on a Macbook for absolute cell reference? You said it in one video and I forgot it. But I don't know which video it is. I can't watch all of them again. You're the only one that knows this shortcut. Please help me.

@ExcelGoogleSheets Жыл бұрын

same, F4 You usually need to press "fn" key to access it.

@Indra-gh1wt Жыл бұрын

permission to ask about wildcards in spreadsheets, if the search key is a serial number instead of text, can this be done? then alternative code "*"&..&"*" ?

@ExcelGoogleSheets Жыл бұрын

You can add wildcards to number, which will basically convert it to a string. The important part is what's in your actual data where you search this? Is it text or number type. If it's number type you'll need to convert it to text.

@motogoa Жыл бұрын

Actually you don't need an array formula if you want to set a range as your search key with XLOOKUP in Google Sheets if you lock the range with F4. Anyhow, great job as usual, thank you!

@ExcelGoogleSheets Жыл бұрын

Really? That seems counter intuitive. Are you sure it's not auto filling the formula automatically?

@lessarafa Жыл бұрын

Do you have any patreon link where we can download your scripts?

@ExcelGoogleSheets Жыл бұрын

www.patreon.com/chicagocomputerclasses

@googleguruji2553 Жыл бұрын

Make a video on Named Function. Pls..

@ExcelGoogleSheets Жыл бұрын

Watch this, it covers pretty much everything you need to know. kzfaq.info/get/bejne/q9uVnJR938DHp2Q.html For something more interesting you can watch LAMBDA Array functions videos kzfaq.infosearch?query=lambda%20array I've recorded these months ago for Excel, now they all work in Google Sheets as well.

@cjanesntos5793 Жыл бұрын

How about multiple matches? How to get the sum amount?

@ExcelGoogleSheets Жыл бұрын

use SUMIFS function

@phoebenguyen3272 Жыл бұрын

Can I have practise file? Thank you.

@ExcelGoogleSheets Жыл бұрын

docs.google.com/spreadsheets/d/1M-eL4Lj62ZrhJKM6x1FugWptwzB3dJLtk0orEFQobsA/edit?usp=sharing

@davode76166 Жыл бұрын

You didn't mention one of the greatest features of xlookup: lookup array can be "after" the result array.

@ExcelGoogleSheets Жыл бұрын

Yes, I did. You should watch the video again. I'm not sure about "greatest" though. :)

@RobinLudvigsen Жыл бұрын

11:26 try value() around text in the formula. Then you don't need to convert

@ExcelGoogleSheets Жыл бұрын

It's probably best to covert in case you have some letters someplace as well, because value will throw an error. But if you only have numbers it should work.