Forum Discussion
Index Match #REF error
=INDEX('Master Equip List'!$A$2:$AI$4632,MATCH(E7,Table13[UNIT'#],0)) New sheet to be built as a sub ledger to the master equipment sheet and only to pull units that we add tot he sheet but to ...
Perhaps the MATCH result returns a number greater than the # or rows in the INDEX table?