Excel Advanced VLOOKUPS kzread.info/dash/bejne/ioOHyKVrYrneqaQ.html Excel Advanced Formula Tricks kzread.info/dash/bejne/nZps2MN6ZbjapJc.html Excel Find Last Non-Blank Cell Value, Row or Column kzread.info/dash/bejne/pXmZ2JKeo7yTmc4.html

@tarigeltayeb413

Жыл бұрын

how to make xlookup sort results in column?

@jerkin6959

Жыл бұрын

My problem the zero not change😢

XLOOKUP is awesome. I learn something new in each of your videos. Using the CHOOSE function as well as returning custom values if not found was mind blowing for me. Great video. 2 Thumbs up.

@rachelmiller2280

2 жыл бұрын

For me too! Game changer!!!

You have earned a new subscriber today.

Excellent! Simple video with lot of information! 😊

This is gold! Amazing! I’d love to see this for Google Sheets.

@20042004Zorro

2 жыл бұрын

=Query() is what you're probably looking for

Sir using xlookup for array it is returning #VALUE! error, while normal return for single column output but fails for multiple returns.. plz help

Awesome tutorial, thanks a lot

@ExcelGoogleSheets

2 жыл бұрын

:)

Thanks a lot 😊

Hello, nice video thank you, a question how do you search if the columns are not next to each other, VB the first product is in column B with 20 rows below it, the 2nd in column F the 3rd in J how do I proceed?

Important - can we use two lookup values instead of one?

Hello, why when i try this formula xlookup with choose, my result is spilling down not right ? I have microsoft 365.

superb

if my lookup value in three different column and i want to return from only one column how to use xlookup than ?

Very cool! Can you get a spilled array result from XLOOKUP, if you give it an array as the first argument? Then one cell would have everything!

@ExcelGoogleSheets

2 жыл бұрын

Yes.

Hallo sir Can you please make video on this topic : How to setup page like A3 ,A4 and make pdf of a particular page Using app script & Also set-up margin and page break up using app script . Please help me 🙏 In Google sheets only

Maybe you can only select multiple columns on the paid version of excel? This isn't working on the online version. I get value error when i try this.

I have tried to use this formula but my is getting to heavy to respond can you some other method

I can't press F4 on my laptop , any idea how to fix ,because when I press it close all windows like an exit

Hi, please when I want to copy the result as value(D2:D10) the result in E2:E10) Disapears, please help

if we would like to change sequence of header in choose function by selecting data validation list, what do we need to change? Because you wrote hard code in Choose function ({1,2,3}) and it can’t be changed by selecting different options.

@ExcelGoogleSheets

2 жыл бұрын

Depends on your setup. Not exactly sure where you validation is and what it contains.

@teoxengineer

2 жыл бұрын

@@ExcelGoogleSheets it contains your table header

@ExcelGoogleSheets

2 жыл бұрын

I'd suggest using INDEX->MATCH if you want to use headers. It will be much easier than XLOOKUP.

@ExcelGoogleSheets

2 жыл бұрын

Here is an example how kzread.info/dash/bejne/ZIiTwbuynsKolNo.html

What if I want to remove the spaces that have a blank or 0 return?

@ExcelGoogleSheets

2 жыл бұрын

What you mean by "remove the spaces"

Is there a way to leverage this function to return multiple matches? I have a file I need to search that has a different number of matches. To use your example - if Brand was in the item I was looking to match size and price against. Is that possible?

@ExcelGoogleSheets

Жыл бұрын

No. Use FILTER function instead kzread.info/dash/bejne/kaV5xZp8dcq7nJc.html

@ExcelGoogleSheets

Жыл бұрын

Actually, this is probably what you need instead kzread.info/dash/bejne/o2ifu6lqgsW6mcY.html

@karenwridt3518

Жыл бұрын

@@ExcelGoogleSheets Thanks! I'll check them out!

Is there any XLOOKUP in Google sheet? If yes then plzz make a tutorial about that..

@ExcelGoogleSheets

2 жыл бұрын

VLOOKUP is XLOOKUP for Google Sheets.

how to make xlookup sort results in column?

@ExcelGoogleSheets

Жыл бұрын

Sort which results?

I follow your directions exactly and receive #spill error even though there are duplicate lookup values

@kuunami

11 ай бұрын

I have the same problem. Did you figure it out?

When i choose multiple columns as the return array, i get "#Value!" Error . Can someone help me?

@kuunami

11 ай бұрын

I'm having the same problem. When I select only one column it's fine.

How can we print the names of the combined workbooks in your "kzread.info/dash/bejne/qmZ31JuhmZaznrw.html" video in the first or last column? When too many books are combined, it cannot be understood which data is taken from which workbook. Thank you very much in advance for your help.

@aytekineraslan4531

2 жыл бұрын

Hi, I asked this question under your other video. Will you help or do you just read and pass the comments? I enjoy watching your videos and I look forward to your new videos. I hope you can help me with this. (I have 450 workbooks. I want to combine them and use them as database, but I need to print the workbook name in an empty column in the merged workbook. Otherwise, merging the workbooks does not make any sense. I hope you will write an answer that will solve my comment.)

@ExcelGoogleSheets

2 жыл бұрын

File object has getName() and getUrl() methods you can use to get the name or url of the spreadsheet.

@aytekineraslan4531

2 жыл бұрын

@@ExcelGoogleSheets Hi, First of all, thank you very much for your reply. I've watched your videos many times, but I couldn't quite understand how to do it. I would be very grateful if you could write more clearly what changes or additions I should make on which line.

Waiting for that formula on Google Spreadsheetq

@20042004Zorro

2 жыл бұрын

Use QUERY function