INDEX MATCH Excel Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 9
MAZEX
Hi Kevin
I have watched all your tutorial video on Index and Match and find them very educating.
Now, I have been given the assignment to create a -Statement of Account- for our supplier. I have a series of Supplier Codes for each supplier such as -001- and so on. When I type the supplier code in one column, I should get the name of the supplier name in reference to the said code. For example, If I am typing supplier code 001 and the supplier name to this code is -ABCDEFGH- should automatically reflect on the next column. In this regard what would be the formula for a supplier's name in reference to that supplier code using data validation?
Your co-operation is highly appreciated.
Best regards
Arif Shaikh
reply
Hi Kevin
I have watched all your tutorial video on Index and Match and find them very educating.
Now, I have been given the assignment to create a -Statement of Account- for our supplier. I have a series of Supplier Codes for each supplier such as -001- and so on. When I type the supplier code in one column, I should get the name of the supplier name in reference to the said code. For example, If I am typing supplier code 001 and the supplier name to this code is -ABCDEFGH- should automatically reflect on the next column. In this regard what would be the formula for a supplier's name in reference to that supplier code using data validation?
Your co-operation is highly appreciated.
Best regards
Arif Shaikh
reply
Biggtyger
Thank you so much for all your videos. Super helpful and insightful.
I have an issue ,and I-m no pro at Excel. Hoping this is an easy fix. For a pro like yourself.
At work I have a sign out sheet. I have a worksheet with drop-downs for items/ qty / description.
On a separate sheet I have prices I manually enter.
Is there away to combine these on one spreadsheet to automatically add the price to a specific item when I choose it in the drop down?
Again I know this is probably basic. Just hoping to find an answer. Thank you, and have an awesome day.
reply
Thank you so much for all your videos. Super helpful and insightful.
I have an issue ,and I-m no pro at Excel. Hoping this is an easy fix. For a pro like yourself.
At work I have a sign out sheet. I have a worksheet with drop-downs for items/ qty / description.
On a separate sheet I have prices I manually enter.
Is there away to combine these on one spreadsheet to automatically add the price to a specific item when I choose it in the drop down?
Again I know this is probably basic. Just hoping to find an answer. Thank you, and have an awesome day.
reply
Juan
Hey Kevin, great training videos. Thank you! I am wondering if you have a video that shows how to connect Excel to Google Sheets and not Google Sheets to Excel. I work with an agency that likes to save all their files in Google Drive. However, our laptops are equip with Excel and we preferred to use Excel to create our workbooks but we would like the ability to update Excel and then Google Sheets will self update. Your help is greatly appreciated. Thank you! JC
reply
Hey Kevin, great training videos. Thank you! I am wondering if you have a video that shows how to connect Excel to Google Sheets and not Google Sheets to Excel. I work with an agency that likes to save all their files in Google Drive. However, our laptops are equip with Excel and we preferred to use Excel to create our workbooks but we would like the ability to update Excel and then Google Sheets will self update. Your help is greatly appreciated. Thank you! JC
reply
Hey
Hi Sir, can you pls help me?
Why all of a sudden i lost my admin rights in my admin user account. I cldnt view task manager, cldnt view a guest account i made, cldnt go to safe mode, cldnt use restore, cldnt alter anything with admin rights. I dont even remember changing anything, what possibly cld have happened? By the way, Im using windows 10, my laptop is personal and as far asi know, i am the only one using my laptop.
Thanks.&
reply
Hi Sir, can you pls help me?
Why all of a sudden i lost my admin rights in my admin user account. I cldnt view task manager, cldnt view a guest account i made, cldnt go to safe mode, cldnt use restore, cldnt alter anything with admin rights. I dont even remember changing anything, what possibly cld have happened? By the way, Im using windows 10, my laptop is personal and as far asi know, i am the only one using my laptop.
Thanks.&
reply
Kunal
Hey Kevin, thank you for the informative video and this will empower many of us in our daily lives.
Suggestion : If we working with multiple sheets and need to share the final sheet with other people, they are not able to view the data unless they have the other reference sheets, can you make a video on how to fix this ?
reply
Hey Kevin, thank you for the informative video and this will empower many of us in our daily lives.
Suggestion : If we working with multiple sheets and need to share the final sheet with other people, they are not able to view the data unless they have the other reference sheets, can you make a video on how to fix this ?
reply
Upendra
So perfectly taught. I have been using vlookups on my office work, which has its limitation of reading data direction. But in index match it is quite free to read data anywhere in sheet. Thanks Kevin
reply
So perfectly taught. I have been using vlookups on my office work, which has its limitation of reading data direction. But in index match it is quite free to read data anywhere in sheet. Thanks Kevin
reply
Anton
Using index match as I write this comment. Advanced example 2 is exactly what I was looking for because -and- function did not help. Thank you.
reply
Using index match as I write this comment. Advanced example 2 is exactly what I was looking for because -and- function did not help. Thank you.
reply
Norman
Thank you Kevin for your informative tutorial. I will definitely be using this in my business for looking up prices of my items I sell.
reply
Thank you Kevin for your informative tutorial. I will definitely be using this in my business for looking up prices of my items I sell.
reply
Dion
Why would I use INDEX/MATCH rather than XLOOKUP. The latter seems easier and functionally identical (but I may well be missing something).
reply
Why would I use INDEX/MATCH rather than XLOOKUP. The latter seems easier and functionally identical (but I may well be missing something).
reply
Add a review, comment
Other channel videos
