Main Profile

At A Glance

Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup

See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) excelisfun: Names, INDIRECT function and the Space Intersector Operator in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) YTL Excel #119: Amazing Lookup Solution! Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup Excel Name Trick #7: INDIRECT function, Names and LOOKUP Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup MrExcel's Learn Excel #965 - Two-Way Lookup Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH
Length: 06:20

Contact

Questions about Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup

Want more info about Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question