Index Match Formula in Excel - Malayalam Tutorial

[@anishmanoharan6701]

I was using the Vlookup and H lookup from last 9 years and I was not aware about this Index Match Lookup 😒.. You really saved my time buddy.. Thanks bro

[@manikandankrishnan9584]

Applied in my excel data index match function to retrieve data of extreme left column. Very Happy to get results. Ur teaching skills are absolutely wonderful.

[@XLnCADMalayalam]

Thank you :)

[@kovilipradeep]

വിശദീകരിച്ചു തരുമ്പോൾ Keayboard Shortcut ഉപയോഗിക്കാതെ മൗസ് ഉപയോഗിച്ച് തന്നെ ചെയ്യുമ്പോൾ എല്ലാവർക്കും വ്യക്തമായി മനസ്സിലാക്കാൻ കഴിയുന്നു... 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

[@muhammednishad7342]

Short cut use ചെയ്യുമ്പോൾ അത് കൂടി പടിച്ചൂടേ. Better use short cut

[@sunilkumarak5793]

ഉപയോഗിക്കുന്ന Short cut, സ്ക്രീനിൽ കാണിക്കുന്നുണ്ട്

[@vinupaul1190]

Short cut use ചെയ്യുന്നതാണ് ഏറ്റവും നല്ലത് തുടക്കത്തിൽ ബുദ്ധിമുട്ട് തോന്നിയാലും പോകെ പോകെ അതിന്റെ എളുപ്പം മനസിലാകും

[@SunilKumar-dz3dv]

Your teaching & explanation skill is very good,
and good match function

[@XLnCADMalayalam]

😀 Thank you

[@rejisd8811]

Thank you. this vdo helped me to resolve one of my case .

[@XLnCADMalayalam]

Great to hear! :)

[@ajeshnair4682]

your voice over is simply outstanding

[@XLnCADMalayalam]

Thank you :)

[@Hari-n4f]

And the way he explains, so patient.

[@John-rt2mg]

thank you so much for sharing your knowledge

[@XLnCADMalayalam]

My pleasure :)

[@jamestharani7935]

Thanks a lot for this video

[@XLnCADMalayalam]

😀

[@Hari-n4f]

Does it have any special use as xlookup does all these. Using combination of various functions is really thrilling. Xloop is a ready to use function whereas index function needs imagination and concentration. Can you pls give us more with combination functions and use??? Thanks Mr Ajay.

[@soorajbhavaan1813]

Nicely described thanks

[@XLnCADMalayalam]

Most welcome 😊

[@my2cuteangels]

നല്ല അവതരണം 👍🏻

[@XLnCADMalayalam]

Thank you :)

[@abhilashanto2546]

Excellent video, thank you !!

[@XLnCADMalayalam]

Glad you liked it!

[@indira6699]

Hi sir for better presentation, we can use Data validation feature for planet selection,then it will be more dynamic.Thank you

[@nallavaan1002]

Thanks sir use full video

[@XLnCADMalayalam]

Glad to hear that and Thank you :)

[@aneeshkg3110]

ഒരു കമ്പനിയിലെ 3 dept എൽ വർക്ക് ചെയ്യുന്നവരുടെ പേരുകൾ 3 column ഇൽ കൊടുത്തിരിക്കുന്നു. ഇതിൽ നിന്നും ഒന്നിലധികം dept ൽ work ചെയ്യുന്നവരുടെ പേരുകൾ ഏത് function ഉപയോഗിച്ച് കണ്ടെത്താം

[@XLnCADMalayalam]

Use COUNTIF function to the find the employees, whose names are repeated multiple times.

[@sreesmusicworld6378]

Excellent Video..👍👍

[@XLnCADMalayalam]

Thank you! Cheers!

[@jijeeshpadmanabhan350]

Very informative

[@XLnCADMalayalam]

Glad you think so!

[@anwarsadath897]

Thanks 😊

[@XLnCADMalayalam]

You're welcome!

[@Keralasown]

USEFUL 👍 TIPS

[@XLnCADMalayalam]

Thank you :)

[@ananya8060]

Hi, video is most help full. Thanks a lot. One doubt. Suppose the data is in another page, then what changes need in the formula. Pls lwt me know. By prem

[@XLnCADMalayalam]

Please check my video on how to VLOOKUP into other worksheets of a workbook.

[@jacobjohnzy4486]

Kollam

[@محمدكايفادات]

it will be very heipful if you share the worksheet also

[@XLnCADMalayalam]

60+ practice files (Excel Workbooks) are made available with my online course on Excel. Link for enrolling into course is given in the description of the videos.

[@rph9837]

Hi
Will this work if we have two different work sheets. I got error

[@arunsagar5342]

Good video. But one doubt.Index match inte same use thanne aano xlookup function um provide cheyunnath

[@XLnCADMalayalam]

INDEX+MATCH formula is a combination of two Excel functions, meant to find a matching value and return corresponding results. XLOOKUP is in many ways different than INDEX+MATCH formula and can handle different lookup requirements.
Please go through my videos on XLOOKUP function for more details.

[@manojkgeorge7314]

THANKYOU

[@XLnCADMalayalam]

You are welcome :)

[@aldhahabifoodstufftrading5427]

company name search cheyth aa companiyude payment and invoice (statement)yedukkanulla formula paranju thraavo?

[@XLnCADMalayalam]

You can use different tools like Find (Ctrl + F) or Filter depending on the size and format of your data.

[@Sabisusmitham]

Index match function use cheyyumbol match functionte ullil multiple column search cheyyan entha vazhi... Multiple column search cheyyan solution undo

[@mathewsc.g1467]

MATCH 2 OR MORE CELLS DATAS IN SAME RAW WITH ANOTHER DATAS IN 2 OR MORE CELLSA AND ARRANGE THE MATCHED DATAS IN SAME ROWS AND PLACE IN TOP OF THE SHEET. IS IT POSSIBLE.
IF POSSIBLE PLEASE HELP.
BECAUSE IT HAS WIDER APPLICATION IN GST INVOICE COPARISON NOW A DAYS FOR GSTR 2B/2A INVOICE COMPARISONS.
THANKS IN ADVANCE.

[@XLnCADMalayalam]

Can you please explain this with an example?

[@jayakumarv1120]

Look up Value search for two arguments, how can match

[@vijeshvincent4308]

I converted the Data into table and tried to apply index & match.but when copy pasting the formula down it is not coming..what is the reason?

[@XLnCADMalayalam]

Can you share the formula used in the first two or three cells.

[@anandhari5239]

Ee absolute value akkunathinte importance entha

[@XLnCADMalayalam]

Please refer my video on Absolute, Relative and Mixed references in Excel.

[@Caferazr]

👌

[@suhailnellaya]

INDEX MATCH function mattoru sheetil ninnum engane return cheyyum?

[@XLnCADMalayalam]

Please check my videos on applying VLOOKUP on multiple worksheets and Excel Tables. You can use the same technique with INDEX+MATCH formula.

[@gireeshkumaredolipattil959]

Any online class available

[@XLnCADMalayalam]

The link for enrolling in my online course on Excel is given in the description of the video.

[@joypoulose9080]

Shop billingൽ ഇത് vlookup പകരം index match എങ്ങനെ ഉപയോഗിക്കാം എന്ന് ഒരു വീഡിയോ തയ്യാറാക്കിയാൽ നന്നായിരിക്കും എന്ന് തോന്നുന്നു.

[@shahidaalikkal7616]

Absolute value aakunnathin f4 allathe vere enthelum method undo?

[@XLnCADMalayalam]

You can add the Dollar Sign ($) manually.

[@shahidaalikkal7616]

@@XLnCADMalayalam thank you

[@jithinraj7468]

Video Nannayittund but oru karyam...ee video il kaanikkunne pole data eppazhum static aakanam ennillalo..athayath column number matram koduthal aa column left ilekko rightilekko onnu maariyal incorrect data aakum result...so better select entire table as range, and give particular column header name instead of just giving column number. Just a suggestion...👍

[@XLnCADMalayalam]

Thank you for the suggestion.

[@ajinpothera4631]

Index match - some line not working

[@haseebk313]

പേര് ലിസ്റ്റിൽ നിന്നും HR കളുടെ പേരുകൾ മാത്രം എങ്ങനെ എടുക്കാ

[@XLnCADMalayalam]

Please check my video on FILTER function in Excel.

[@premjithpereppadan2783]

Pls improve sound quality

[@XLnCADMalayalam]

Sure and thank you for the suggestion.

[@kurienillirickal7195]

Xlookup ഇൻ്റെ അടുത്ത് index match മാറി നിൽക്കും. Xlookup വളരെ എളുപ്പവും

[@XLnCADMalayalam]

👍