Two Way Lookup Formula and Conditional Formatting!
See Mr Excel and excelisfun use two methods to:
1. Mr Excel creates formula to do Two Way Lookup using INDEX and 2 MATCH functions
2. Excelisfun creates formula to do Two Way Lookup using VLOOKUP and MATCH functions
3. Excelis fun creates Conditional Formatting to highlight the column, the row and the intersecting cell in the two way lookup table using Mixed Cell References, the LOOKUP Function and the AND Function in three logical formulas.
4. Mr Excel using Conditional Formatting to highlight the two way lookup intersection cell using the build-in Conditional Formatting feature “Cell Contains”