100 hours and 200 so called excel gurusr, criss cross the desert, given up hope, suddenly miraculously this Oasis- where I found what I need to know. Thank you 😘
Hello! I'm from Pakistan and I work for Florida based insurance company remotely as a freelancer. I get a lot of help from your channel. Thanks man. I ❤️ you. Mwah 😘
Nice, thanks! How would you do if the other report from where we are getting the columns had some filters on those columns which you want to bring to another sheet? Do you have any videos of that? Thanks
Sure, you could do that. Since I tend to convert things to tables in Excel, I'm not concerned about copying down, it happens automatically with tables anyways.
In your opinion, whats the best way to find a cell containing "abc" or similar value in it and copy its entire content to another sheet? Ive tried LOOKUP, MATCH, INDEX with no sucess.
@@ExcelGoogleSheets it says that the answer is a text and therefore cannot be force into a number. In my case i have a scrambled database, in wich my columns arent where they are supposed to be, so iam tryin to copy the cells containing certain words in the right column in other sheet
Hi mate, I am one of your subscriber and learned how to xlookup on csv files. I use xlookup in csv file to update shopify shop inventory as shopify only accept csv format. But the problem is when you use xlookup and after you close the file the xlookup function does not save and lost the formula. Please help if this is something wrong with my version of excel or the formulas doesn't not work with csv format. By the way i am using the lasters version of Microsoft 360.
Hello Sir I am from Doha Qatar 🇶🇦 How to leave 1 or 2 columns and then value Plz explain Like I have in column 2 ID and then 2,3,4,5 columns for the remarks manually and then I want to get the value Thank you
100 hours and 200 so called excel gurusr, criss cross the desert, given up hope, suddenly miraculously this Oasis- where I found what I need to know. Thank you 😘
🙂
Just wanted to say this worked great! Thanks for the help!
👍
Hello! I'm from Pakistan and I work for Florida based insurance company remotely as a freelancer. I get a lot of help from your channel. Thanks man. I ❤️ you. Mwah 😘
:)
Thank you! Thank you! Thank You! Thank you!!!!!!!!!!
Finally the right info
exactly what I need
Thank you 😊
Great explanation 👌
Thank you 🙂
Thank you!
:)
Nice, thanks! How would you do if the other report from where we are getting the columns had some filters on those columns which you want to bring to another sheet? Do you have any videos of that? Thanks
Formulas will ignore filters. You'll probably need to use FILTER function to filter your data again.
Very informative
Thank You!
Good stuff! How about an array for the first xlookup() argument? Save all that copying down.
Sure, you could do that. Since I tend to convert things to tables in Excel, I'm not concerned about copying down, it happens automatically with tables anyways.
In your opinion, whats the best way to find a cell containing "abc" or similar value in it and copy its entire content to another sheet? Ive tried LOOKUP, MATCH, INDEX with no sucess.
=VLOOKUP("*abc*",rangeToSearch,1,0)
@@ExcelGoogleSheets it says that the answer is a text and therefore cannot be force into a number. In my case i have a scrambled database, in wich my columns arent where they are supposed to be, so iam tryin to copy the cells containing certain words in the right column in other sheet
@@ExcelGoogleSheets Nevermind, it worked, thank you so much
Bro Need POWER QUERY video pls
Good. Let's assume that if we have multiple values in a ragne and want to extract different values from list by using xlookup.
How can we manage it?
Do you mean multiple row matches or simply multiple columns?
@@ExcelGoogleSheets Multiple row matches...Same name but different values
@@teoxengineer Not possible with XLOOKUP, but you can do this czcams.com/video/oZhccmQTHkA/video.html
Hi mate, I am one of your subscriber and learned how to xlookup on csv files. I use xlookup in csv file to update shopify shop inventory as shopify only accept csv format. But the problem is when you use xlookup and after you close the file the xlookup function does not save and lost the formula. Please help if this is something wrong with my version of excel or the formulas doesn't not work with csv format. By the way i am using the lasters version of Microsoft 360.
File-Save As change to an Excel file.
มันใช้ไม่ได้กับ Excel ครับ โหลดออกมาแล้ว Error หมดเลยครับ แล้วใช้สูตรเหมือนกันก็ทำไม่ได้
4:18
Hello Sir
I am from Doha Qatar 🇶🇦
How to leave 1 or 2 columns and then value
Plz explain
Like I have in column 2 ID and then 2,3,4,5 columns for the remarks manually and then I want to get the value
Thank you
Do you have HSTACK function available in your version?
@@ExcelGoogleSheets thank you so much Sir,
I got idea from your video
So it's solved
Thanks again
👍
That doesn’t work