Return Multiple Values with Single Xlookup Statement

In this lesson, we learn how to return multiple values from a data set with a single Xlookup Statement. No need to write several statements, as long as the columns are in consecutive order.

[meniporat]

Here's a trick to fetch all the values (even from non-adjacent columns) in one XLOOKUP statement.
No need to bring the Date column in a separate statement:
=XLOOKUP(H6, A6:A23, CHOOSECOLS(B6:F23, {1, 2, 3, 5}))
This formula will return data from the following columns: Name, Level, Price, Date

[warrenanderson]

Well ladies..here is what you are looking for ..a tall young good looking black male who makes over $100K. This is that attitude make like this have. They are the table... not baby momma's out of shape with tons of makeup, weaves, drunk/ high, and cursing. And before anyone says anything.. I am in that category myself ( other than then being in my 30's).

[EvanSarris]

I’m curious as to why you went through the trouble of going to the FORMULA RIBBON, clicking on the INSERT FORMULA icon then typing in the XLOOKUP FORMULA when you could have just put the cursor into the cell where you want the formula and type =XLOO… which brings up your function choices with XLOOKUP coming up as the first choice. Then hit the tab key and your formula appears. This is not a put down but rather a sincere inquiry. Thanks

[viveksahu]

Nice video....I was using an older version of Excel and did the same thing using vlookup function.

[montebont]

Waste of time. This is yet another (I stopped counting at about 300) example of bad data structuring and a solution looking for a problem that should not exist in the first place.
If you want to use Excel as a database I suggest you first learn how databases and normalization work...