How to use Index and Match function (Advanced Excel)

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

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

50% 1

How to use Index and Match function
: Learn how to overcome limitations of Vlookup function with Index Match functions.
This video includes examples of how to set up and use this data validation function for a two-way lookup.
Tutorial for Index Function: • How to use Index Funct...
Tutorial for Match Function: • Video
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
*Link to get Microsoft Office 365:*
microsoft.msaf...
Disclosure: The above link is an affiliate link, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

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

1 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@ganeshprasadtp9704 4 года назад

I could not understand index and match although I watched many videos, but after watching this video, I’m not going to forget it in my life, this video made it so crystal clear.

@colinhuntley9729 4 года назад

an excellent tutorial! your explanation was easily explained and easy for me to understand. after finding your youtube channel, i will be a regular visitor...

@vadirajasharma7020 5 лет назад

Sir, I am continuously watching your videos on PPT and also on excel. I have also done a course offered by you through Udemy. I really love the way you explain the things so lucidly, which is very easy to comprehend and follow. I have a suggestion, when you are using an excel file, you may allow them to be downloaded for practising which immensely helps towards the reinforcement of our learning.

@shubhangi185able 5 лет назад

Can you please also have a tutorial on types of pivot table and vlookup between diff files and sheets

@jimmyni1983 5 лет назад

Great explanation! Thank you so much!

@PresentationProcess 5 лет назад

Thank you so much for watching and commenting!

@princekamboj1620 4 года назад

Excellent videos !! Have watched so many videos but this one indeed best one and easy to understand with practical knowledge.. Sir any program on Excel on Udemy alike PPT .. Please let me know ...

@Joharfinalfighter 5 лет назад

मुझे बहुत उम्मीद है कि आप इस सवाल का जवाब देंगे सर

@kamaleshmondal337 4 года назад

Could you make a video in multiple criteria of index match. More than 4 criteria depends.

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

THANKS A LOT RESPECTED SIR VERY INFORMATIVE VIDEO

@shubhangi185able 5 лет назад

Easy to use explanation.. precise and engaging

@PresentationProcess 5 лет назад

Thanks for the feedback and suggestion!

@Joharfinalfighter 5 лет назад

झारखंड सरकार कर्मचारी चयन आयोग में एक एग्जाम हो रहा है सर जी इसीलिए पावरप्वाइंट प्रेजेंटेशन से एक सवाल पूछना है 1.चार अलग-अलग स्लाइड में रखे गए कॉलम चार्ट या कोई से shape स्लाइड बीचो बीच में रखने हेतु कौन सा तरीका

@moviesmore6220 5 лет назад

बीचों बीच का क्या मतलब है? बताएं तो शायद मैं हेल्प करूँ.

@Joharfinalfighter 5 лет назад

जैसे एमएस एक्सल में कोई भी चार्ट बनाएं फिर वहां से chart कॉपी किए ppt के स्लाइड में chart को past किये अब यहां पर स्लाइड बहुत सारा बनाना है इस तरह से ,,तो जो chart कॉपी पेस्ट करेंगे वह स्लाइड के एकदम बीच-बीच में एक साथ कैसे रखना है