Index Match Formula in Excel - Malayalam Tutorial

Подписаться 160 тыс.

Просмотров 32 тыс.

50% 1

എക്സലിലെ ഇൻഡക്സ് മാച്ച് ഫോർമുല എങ്ങിനെ ഉപയോഗിക്കണം എന്ന് വിശദീകരിക്കുന്ന വീഡിയോ.
How to use INDEX MATCH Formula in Excel, explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel ‪@AjayAnandXLnCAD‬ for more.
/ ajayanandxlncad
മൈക്രോസോഫ്റ്റ് എക്സൽ ഇത് വരെ ഉപയോഗിച്ചിട്ടില്ലാത്തവർക്കും, പഠിച്ചു തുടങ്ങാൻ ആഗ്രഹിക്കുന്നവർക്കും വേണ്ടി . . .
• Microsoft Excel Tutori...
#ExcelMalayalam #MalayalamTutorial #indexmatch

Опубликовано:

12 ноя 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 75

@anishmanoharan6701 3 года назад

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

@kovilipradeep 2 года назад

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

@muhammednishad7342 2 года назад

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

@sunilkumarak5793 Год назад

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

@vinupaul1190 6 месяцев назад

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

@vivekiv6696 Год назад

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

@manissery1956 2 года назад

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.

@abhilashanto2546 3 года назад

Excellent video, thank you !!

@XLnCADMalayalam 3 года назад

Glad you liked it!

@John-rt2mg 2 года назад

thank you so much for sharing your knowledge

@XLnCADMalayalam 2 года назад

My pleasure :)

@Sabisusmitham 2 года назад

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

@rejisd8811 Год назад

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

@XLnCADMalayalam Год назад

Great to hear! :)

@manikandankrishnan9584 3 года назад

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 3 года назад

Thank you :)

@SunilKumar-dz3dv Год назад

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

@XLnCADMalayalam Год назад

😀 Thank you

@aneeshkg3110 2 года назад

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

@XLnCADMalayalam 2 года назад

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

@jayakumarv1120 3 года назад

Look up Value search for two arguments, how can match

@sreesmusicworld6378 2 года назад

Excellent Video..👍👍

@XLnCADMalayalam 2 года назад

Thank you! Cheers!

@soorajbhavaan1813 2 года назад

Nicely described thanks

@XLnCADMalayalam 2 года назад

Most welcome 😊

@nallavaan1002 3 года назад

Thanks sir use full video

@XLnCADMalayalam 3 года назад

Glad to hear that and Thank you :)

@rph9837 Год назад

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

@jamestharani7935 Год назад

Thanks a lot for this video

@XLnCADMalayalam Год назад

😀

@ajeshnair4682 2 года назад

your voice over is simply outstanding

@XLnCADMalayalam 2 года назад

Thank you :)

@manissery1956 2 года назад

And the way he explains, so patient.

@jijeeshpadmanabhan350 3 года назад

Very informative

@XLnCADMalayalam 3 года назад

Glad you think so!

@anwarsadath897 3 года назад

Thanks 😊

@XLnCADMalayalam 3 года назад

You're welcome!

@Keralasown 3 года назад

USEFUL 👍 TIPS

@XLnCADMalayalam 3 года назад

Thank you :)

@my2cuteangels Год назад

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

@XLnCADMalayalam Год назад

Thank you :)

@jacobjohnzy4486 2 года назад

Kollam

@joypoulose9080 2 года назад

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

@Caferazr 3 года назад

👌

@manojkgeorge7314 3 года назад

THANKYOU

@XLnCADMalayalam 3 года назад

You are welcome :)

@ananya8060 3 года назад

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 3 года назад

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

@suhailnellaya 3 года назад

INDEX MATCH function mattoru sheetil ninnum engane return cheyyum?

@XLnCADMalayalam 3 года назад

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

@aldhahabifoodstufftrading5427 3 года назад

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

@XLnCADMalayalam 3 года назад

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

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

@vijeshvincent4308 2 года назад

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 2 года назад

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

@user-ld3dk3te1g 2 года назад

it will be very heipful if you share the worksheet also

@XLnCADMalayalam 2 года назад

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.

@mathewsc.g1467 3 года назад

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 3 года назад

Can you please explain this with an example?

@ajinpothera4631 2 года назад

Index match - some line not working

@jithinraj7468 3 года назад

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 3 года назад

Thank you for the suggestion.