TECH-002 - Find a value in intersecting rows and columns in Excel

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://www.theexcelchallenge.com

Learn how to create a spreadsheet that will allow you to easily find intersecting values between rows and columns.

In this video you will use the formulas MATCH, INDEX, CONCATENATE, you will use Conditional Formatting, you will create Dropdown menus by using VALIDATION in the form of LIST, you will learn how to remove redundant cells and formulas, etc. etc.

I hope this tool is something you can use in your daily routine so you get more with less effort.

If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve the most common Excel challenges from our viewers and subscribers.

Thank you for watching.
Check out our previous video in the links below:

* TECH-001 - Compare data in charts selecting values from dropdown menus
https://www.youtube.com/watch?v=pinGnCjZTpY

Видео TECH-002 - Find a value in intersecting rows and columns in Excel канала The Excel Challenge