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

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

[alanmorrison]

Just found this. Very clear and concise, perfect for what I wanted! Thank you.

[miabennett]

Thanks so much for breaking it down in such a brilliant way!! Best tutorial ever for Index Match...

[vinayverma]

Thanks a ton. I was stuck with a problem for past many hours, you sorted it out easily. Loved the way you explained. Cheers

[gorilla]

Wow that's a complete explanation. I'm a loyal fan now.

[rayrodriguez]

I was stuck and now making some progress. Thanks. Great video.

[arunprasad]

Amazing! I was wondering how to find for one "X", a value which is having multiple "y" values. This video helped me out. Thanks!

[bhushanbachhav]

Thanks you have solve my most pending problem...thanks once again. God bless You.

[jimmymiller]

Thank you, thank you for this tutorial!

[cththedead]

Very good, easy to understand tutorial

[bgurram]

Hey, thank you very very much, you have solved my problems, great

[Knight-Ai]

Thanks, you make it easy for me to learn. Keep going

[mirrrvelll]

And if wanna have "Intersection" formatted with specific color you can add one more formula in conditional format using =AND(from city = Atlanta, to = Atlanta) - with proper referencing.

Great videos, its helpful tough.

[sabuselvi]

the explanation id so clear .. this really helped me, THANK YOU FOR BEING THERE FOR US :)\

[rogersourm]

Thank you for blowing my mind again :D

[shaymaanassar]

Thank you it is very useful to me useful information and professional explanation
I would like to ask about the presentation software used in the explanation

[amanprasad]

Is there a way to only highlight the intersecting cell instead of the whole row or column around it?

[mikesison]

I have a matrix which is a result of a pivot table and I need to look up the value in an intersection and put it in another spread sheet (for all the values) which will be used for mail merge spread sheet. Your video is very clear for 1 intersection. How do I populate the entire mail merge spread sheet with the data from the pivot table? Thanks!

[xinyinhoe]

Thanks alot for this video but may I ask how do we inverse this process? as if I enter "129", then it would return me "Driving from Philadelphia to new york is 129 miles"? Thanks again

[markonikolic]

Any idea, how can i retrieve the column name.. let's say i want to find which city if the most distant from Boston? I would really appreciate it. Thanks guys

[oscarabrego]

What is the best formula(s) and how to use it, which can select multiple cells and show (with color) in a large excel file that contains financial data "between value", example: all cells between 31, 950 to 32, 020, then those between 39, 450 to 40, 100 in the same file.