How to Make Picture Lookup Using Index and Match Function in Excel Bangla
Here i will show you How to Make Picture Lookup Using Index and Match Function in Excel Bangla.This is a ms excel bangla tutorial. I will use ms excel 2016 version but you can use it to any version but better 2008 and on.
In every id card such as Admit card, NID card or passport there is a photo according to thier inputted data. Here i will show you how to make it.
You will just input your data and picture is automatically changed.
Here i will use 3 things to make it
1. Data Validation
2. Index and Match Function
3. Name Manager
Basic Function is Index and match function.
The INDEX MATCH MATCH formula is the combination of two functions in Excel: INDEX and MATCH.
=INDEX() returns the value of a cell in a table based on the column and row number.
=MATCH() returns the position of a cell in a row or column.
The INDEX MATCH function is one of Excel's most powerful features. The older brother of the much-used VLOOKUP, INDEX MATCH allows you to look up values in a table based off of other rows and columns. And, unlike VLOOKUP, it can be used on rows, columns, or both at the same time.
INDEX MATCH is so useful that many Excel pros use it to replace VLOOKUP entirely, never relying on the latter function. It appears frequently in spreadsheets, formulas, and even Excel interviews — so is a great formula to know for business analysts of any tenure.
Before we begin, it is important to realize that INDEX MATCH isn't actually a standalone function, but rather a combination of Excel's INDEX and MATCH functions. Read on to find out how to use them together to activate one of the most powerful tools Excel has to offer.
Apart from VLOOKUP, INDEX and MATCH is the most widely used tool in Excel for performing lookups. The INDEX and MATCH combo is potent and flexible, and you'll see it used in all kinds of formulas, from basic to very advanced.
However, while VLOOKUP allows you to perform lookups with a single function, INDEX and MATCH requires two functions, one nested inside another. Many users find this confusing, because they aren't used to combining functions in Excel, so they avoid INDEX and MATCH. That's a shame. Combining functions is the key to more advanced formulas in Excel.
This article explains in simple terms how to use INDEX and MATCH together to perform lookups. It takes a step-by-step approach, first explaining INDEX, then MATCH, then showing you how to combine the two functions together to create a dynamic two-way lookup.
Picture Lookup Version 1 : • Picture LOOKUP Bangla || How to Create Pic...
Data Validation : • How to Make Drop Down List/Menu Using Data...
Name Manager : • How to Create a Name Manager in Excel || D...
Cell Reference : • Cell Reference :How to Use Relative, Absol...
I think you have enjoyed this video.
If this tutorial really helps you, please #like, #comment, #subscribe and #share with your close friends.
............................................................................
..............Subscribe to Get More Videos...........
https://www.youtube.com/c/MaMuNAcadem...
............................................................................
..................................................................................................
Most Favorite Videos
MS Excel Bangla Tutorial Playlist :
Microsoft Excel Super Tips & Tricks: Must Know: https://goo.gl/5qSphJ
IF Function in MS Excel Bangla: https://goo.gl/jY76m4
Microsoft Excel Essential Course for Beginners: https://goo.gl/7EX1hk
Microsoft Excel Intermediate Course: https://goo.gl/iatnNz
Microsoft Excel Advanced Course: https://goo.gl/WFrvzU
Microsoft Excel Formulas & Functions: https://goo.gl/7Da7oZ
Microsoft Excel Pivot Table Magic: https://goo.gl/NGp13W
Microsoft Word Essential Course: https://goo.gl/SVXefG
..................................................................................................
.................Social Media.................
Twitter : / cumamun
Google+ : https://plus.google.com/mamunacademy
LinkenIn : / abdulla-al-mamun-172629b4
Instagram: / al-mamun36
..............................................
........................................................
Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.