Excel Forum
Similar Content
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 Exce...
Get Data from the Worksheet into a Macro in Excel
Tutorial: Here, you'll learn how to get information from the Excel worksheet into a macro so you can...



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.