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
@austenausten12668 ай бұрын
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?
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.
@Allen-L-Canada Жыл бұрын
I have a vlookup formular, how do I convert to XLOOKUP? | =VLOOKUP("MODEL 1",{IMPORTRANGE($B2,"DCF!D9:N13")},10,false) | thanks!