Index Match question
Posted on 2013-12-06
Hi Guys, if I do a INDEX MATCH to another spreadsheet. Will it work if you use a Named Range?
Also, has anyone any idea how to shorten my lookup path just to include the Name of the external spreadsheet from:
=IF(ISNA(INDEX('V:\Treasury Finance Controls\Ledger v SS Recs\Recs - Murex_GBO\2013 Recs\12_2013 Recs\BS\[Murex BS rec breaks - 041213.xlsm]Rec'!$B$3:$AL$1000
=IF(ISNA(INDEX(Murex BS rec breaks - 041213.xlsm]Rec'!$B$3:$AL$1000]