Dueling Excel 001

Two 2 Way Lookup

DESCRIPTION

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)

WORKBOOKS

Download “Dueling Excel 001-010” Dueling-Excel-001-010.zip – Downloaded 0 times – 116 KB




Be the first to comment

Leave a Reply