XLOOKUP - Return Multiple Columns (Values) in Excel

[@ExcelGoogleSheets]

Excel Advanced VLOOKUPS kzbin.info/www/bejne/joC2l3ZoZ7urr6M Excel Advanced Formula Tricks kzbin.info/www/bejne/oZebp5R3arqnqpY Excel Find Last Non-Blank Cell Value, Row or Column kzbin.info/www/bejne/qXbIp2ObqL5gn80

[@tarigeltayeb413]

how to make xlookup sort results in column?

[@jerkin6959]

My problem the zero not change😢

[@MrDoubleYa]

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]

For me too! Game changer!!!

[@leostar1100]

Excellent! Simple video with lot of information! 😊

[@SaurabhMishra-g3o]

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

[@MohammedAli-bz6ij]

You have earned a new subscriber today.

[@shoppersdream]

Nice, thanks! It was nice to see how to get any number of columns and they don't have to be side by side. Please always upload a Sample file so that we can practice with you.Thanks

[@nikolaypetrov8621]

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

[@TheSize42]

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

[@gerardvaneggermond2067]

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?

[@mushfiqulislam8898]

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

[@kuunami]

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.

[@BlueSkyGoldSun]

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

[@strive2heal]

when i try to do this with arrayformula, it would only return the 2nd column. is there any way I can work around this?

[@ExcelGoogleSheets]

What's your formula?

[@michaelwinter742]

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

[@20042004Zorro]

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

[@pankajpanchal7863]

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

[@MAFA.ACADEMY]

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

[@PartTimeHero77]

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

[@ExcelGoogleSheets]

What you mean by "remove the spaces"

[@karenwridt3518]

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 kzbin.info/www/bejne/laKolGt5esyIopY

[@ExcelGoogleSheets]

Actually, this is probably what you need instead kzbin.info/www/bejne/p2XOinpnh8eHn8U

[@karenwridt3518]

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

[@shoppersdream]

I tried it today. It works if your data is not in a table but if it is in a table then CHOOSE Function didn't work for me. Have you tried it with tables? Thanks

[@ExcelGoogleSheets]

Use HSTACK(Table[col1],Table[col2],Table[col3])

[@shoppersdream]

@@ExcelGoogleSheets Thank you! I will try and let you know.

[@shoppersdream]

@@ExcelGoogleSheets I tried it and here is the formula but it didn't work. =XLOOKUP([@Name], Table2[Name], HSTACK(Table2[Phone], Table2[ID], Table2[Company])) but thank you for the CHOOSE Formula that works perfectly with range but not with table.

[@ExcelGoogleSheets]

What error did you get with HSTACK?

[@shoppersdream]

@@ExcelGoogleSheets It gave me an error #SPILL!. I had pasted my formula earlier. Looks like it didn't paste. =XLOOKUP([@Name], Table2[Name], HSTACK(Table2[Phone], Table2[ID], Table2[Company]))

[@oryviej]

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

[@kuunami]

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

[@salahderdar5148]

Awesome tutorial, thanks a lot

[@ExcelGoogleSheets]

:)

[@jamesepace]

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]

Yes.

[@teoxengineer]

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]

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

[@teoxengineer]

@@ExcelGoogleSheets it contains your table header

[@ExcelGoogleSheets]

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

[@ExcelGoogleSheets]

Here is an example how kzbin.info/www/bejne/aIXCkIyvo8R1mtk

[@mitoali5151]

why he's pressing f4? could someone explain it?

[@ExcelGoogleSheets]

Watch this kzbin.info/www/bejne/o4W6mWaMhZt7hs0

[@abdullahal8374]

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

[@ExcelGoogleSheets]

VLOOKUP is XLOOKUP for Google Sheets.

[@arghyadutta9091]

Awesome

[@tarigeltayeb413]

how to make xlookup sort results in column?

[@ExcelGoogleSheets]

Sort which results?

[@ashishshiriskar123]

superb

[@blackblue6273]

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

[@kuunami]

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

[@adityadeepakghadge5738]

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

[@ytdavide]

Thanks a lot 😊

[@aytekineraslan4531]

How can we print the names of the combined workbooks in your "kzbin.info/www/bejne/rmOmo2yenpiApLs" 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]

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]

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

[@aytekineraslan4531]

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

[@MrTtayson]

Waiting for that formula on Google Spreadsheetq

[@20042004Zorro]

Use QUERY function