Excel Pro Tricks: Lookup and Return Multiple Specific Non-Adjacent Columns in Excel - INDEX & XMATCH
Вставка
- Опубліковано 11 жов 2024
- Learn how to lookup and return values from multiple specific non-adjacent columns in Excel using a combination of functions in Excel formula.
In this tutorial, we learn how to lookup across multiple columns of data and get values only from specific non-adjacent columns dynamically in Excel.
This technique involves the use of INDEX and XMATCH function to make multi dimensional lookup formula that returns value from non contiguous columns.
Lets Excel!
Access or Download Practice workbook for this Excel tutorial:
1drv.ms/x/s!Ap...
For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel YT channel.
Learn #Excel your way:
===================
Website: learnexceltoex...
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#excel #exceltips #exceltricks #exceltutorial #exceltutorialforbeginners #excelformula #excelfunctions #excelformulasandfunctions #excelformulatypes #exceltable #exceldata #data #dataentry #dataentryjobs #xlookup #lookup #lookupformula #lookupfunction #index #xmatch
Can you please share the condition formatting you used here?
Great content Sir❤❤
Nice, thanks for sharing
Very useful, thanks a lot!!
Glad you find it useful
GOAT, thanks!
excelent yar
Subscribed
There is a problem when selecting sales agent Parah Salin and choosing the month of Jul then the value of the month of the Mar of Morgan prisoner also highlights
No description no link for downloadeing the practice file???
عمل رائع
it's like coding.. this is more on point and select
Amazing
Hi sir...Mere computer me Excel ka old version hai kya usme ye sab sheekh sakte hai ...?
Cool 🎉
Does it work with xlookup too?
❤❤❤❤
Hai… I need a help. I have 10 rows and row wise I have name and I have 7 technologies name as column heading. Those name who knows the technology will mark as Yes and others as No in the cells and blanks also. So if I select the names of technology on a drop-down and yes or No on another drop down I want to get all the names who knows the selected technology. How can I do it
Your table with 10 names, 7 technologies, and the yes/no data should be present on the ws. Put this formula in the top cell of the range where your names will spill to: =CHOOSECOLS(FILTER(HSTACK(Name,INDEX(Data,0,MATCH(TechSelect,Headers,0))),INDEX(Data,0,MATCH(TechSelect,Headers,0))=YesNoSelect),1) Create Named Ranges in your worksheet using this guide: "Name" is the first column in your table, do not include column header. "Data" is all of the data in the table, do not include column headers. "TechSelect" is the cell where your technology selection dropdown is, "YesNoSelect" is the cell where your Yes No dropdown is. "Headers" is the range of cells that make up the top row of your table. Have fun!
Color coding how to do
Condition formatting
Where this practice sheet...???
I tried it but i don't why I don't have filter and coulour is not changing 😢
Bhai ye filter kese aya wo bhi to batao..
Color is not coming in my sheet
Conditional formatting
ITS IS TABLE FORM ?
No
But doesn't matter if table
Where is practice sheet ??
In the description
Hello and congrats for the trick. Btw I don’t see how to download the practice sheet in the description… can you help?
@@hurricane16701 click the 3 dots icon, and then select description. You can see the download link.
I can't see well enough to follow what you're doing, especially at this speed. Narration would help greatly. As it is, this may be the answer to my problem, but it's useless to me.
It's found only in Microsoft 365 😅😢
arnold shawarma🤣🤣🤣
What 😳
Kuch zubaan sy bol KR bhi bata Diya kro
No description no link for downloadeing the practice file???
Practice file is mentioned in the description of this video.