Excel Forum
Similar Content
Excel Formula Formatting Trick to Make Life Easier
Tutorial: This Excel Quickie WILL make your life much easier with long formulas, even if you are al...
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Macro: This Excel macro filters data in Excel to display results that contain 1 of 2 possible val...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Mr Excel & excelisfun Trick 32: Three Methods for 2-Way Look


See Mr Excel and excelisfun do two-way lookup three different ways:
1.INDEX and MATCH functions
2.VLOOKUP and MATCH functions
3.INDIRECT function and the Intersection Operator





Got a Question? Ask it Here in the Forum.