Excel Pro Tricks: XLOOKUP to return Multiple Columns and Rows in Excel formula with XLOOKUP Function

Learn how to lookup and return multiple values from multiple columns at once from the data using Excel XLOOKUP function with this easy to understand trick in seconds.

In this Excel tutorial we learn how to use XLOOKUP function to return multiple values from more than one column against a lookup value. Usually we get only one value, however, XLOOKUP can get us values from all the columns we desire.

Lets Excel!

Access or Download Practice workbook for this Excel tutorial:

For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel YT channel.

Learn #Excel your way:
===================
--------------------------------------

Pick your favourite social page:

#excel #exceltips #exceltricks #exceltutorial #exceltutorialforbeginners #excelformula #excelfunctions #excelformulasandfunctions #excelformulatypes #exceltable #exceldata #data #dataentry #dataentryjobs #xlookup #lookup #lookupformula #lookupfunction

[manjulakarthik]

another method try, index with xmatch , also try dget formula

[varunakarniya]

And the red colour highlight is done by conditional formatting?

Great videos btw, i learn a lot from your channel.

[gamingt]

How to use Conditional formatting for highlight red like this?

[ansaralamansari]

If I want to see data with month wise in this sheet how we can modify

[pratapkeshavpawar]

Going with fast doesn't work steps to step in Little bit

[firdausismail]

I wanna be friend w the guy who's surname is Shawarma 😂

[moazibrahem]

Excuse me, what program do you use for screen recording? please