View all of our Excel Video Tutorials on our New YouTube Channel HERE.
This video tutorial will show you how to make a two-way lookup in excel. This tutorial uses the MATCH() and INDEX() functions to do this lookup. This will enable you to use two separate parameters to search a table of data in excel. This is a very general example and, if you download the spreadsheet, you should be able to modify it sufficiently for your needs.
Topics Covered
 How to Create a Two-Way Lookup Use Multiple Parameters in a Lookup Use the MATCH() & INDEX() Functions in Excel
Difficulty: Intermediate
Video: Yes
Spreadsheet: Yes
 Download Here: 1
|
|
