XLOOKUP - Return Multiple Columns (Values) in Excel

Learn how to use Excel XLOOKUP function & return data from multiple columns with one formula.

#xlookup #excel

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

[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

[leostar]

Excellent! Simple video with lot of information! 😊

[MohammedAli-bzij]

You have earned a new subscriber today.

[SaurabhMishra-go]

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

[gerardvaneggermond]

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?

[nikolaypetrov]

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

[michaelwinter]

This is gold! Amazing!

I’d love to see this for Google Sheets.

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

[TheSize]

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

[mushfiqulislam]

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

[pankajpanchal]

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

[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

[karenwridt]

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?

[MAFA.ACADEMY]

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

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

[blackblue]

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

[adityadeepakghadge]

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

[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!

[PartTimeHero]

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