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 😘

@ExcelGoogleSheets

Жыл бұрын

🙂

Just wanted to say this worked great! Thanks for the help!

@ExcelGoogleSheets

Жыл бұрын

👍

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 😘

@ExcelGoogleSheets

2 жыл бұрын

:)

Thank you! Thank you! Thank You! Thank you!!!!!!!!!!

Finally the right info

Great explanation 👌

@ExcelGoogleSheets

Жыл бұрын

Thank you 🙂

exactly what I need

Thank you 😊

Very informative

@ExcelGoogleSheets

2 жыл бұрын

Thank You!

Thank you!

@ExcelGoogleSheets

2 жыл бұрын

:)

Good stuff! How about an array for the first xlookup() argument? Save all that copying down.

@ExcelGoogleSheets

2 жыл бұрын

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.

Bro Need POWER QUERY video pls

มันใช้ไม่ได้กับ Excel ครับ โหลดออกมาแล้ว Error หมดเลยครับ แล้วใช้สูตรเหมือนกันก็ทำไม่ได้

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

Жыл бұрын

=VLOOKUP("*abc*",rangeToSearch,1,0)

@mrbrooks256

Жыл бұрын

@@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

@mrbrooks256

Жыл бұрын

@@ExcelGoogleSheets Nevermind, it worked, thank you so much

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.

@ExcelGoogleSheets

Жыл бұрын

File-Save As change to an Excel file.

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?

@ExcelGoogleSheets

2 жыл бұрын

Do you mean multiple row matches or simply multiple columns?

@teoxengineer

2 жыл бұрын

@@ExcelGoogleSheets Multiple row matches...Same name but different values

@ExcelGoogleSheets

2 жыл бұрын

@@teoxengineer Not possible with XLOOKUP, but you can do this kzread.info/dash/bejne/oY6cxcWmgbeum6Q.html

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

@ExcelGoogleSheets

Жыл бұрын

Do you have HSTACK function available in your version?

@azhadshamim3122

Жыл бұрын

@@ExcelGoogleSheets thank you so much Sir, I got idea from your video So it's solved Thanks again

@ExcelGoogleSheets

Жыл бұрын

👍

That doesn’t work