Hi All,

I have an array formula setup but the processing of this formula is slowing the calculations down on my file so was wandering if it can be converted to a non-array version to help speed things up a little? The file it is referring to currently contains 136,000 x 2 lines of data!

Formula: copy to clipboard 
=IF([@Shipper]=[@Consignee],INDEX([DataFile.xlsx]Partner!$A:$B,MATCH([@Consignee],[DataFile.xlsx]Partner!$A:$A,0),2),INDEX([DataFile.xlsx]Partner!$A:$B,MATCH(1,([@Shipper]=[DataFile.xlsx]Partner!$A:$A)+([@Consignee]=[DataFile.xlsx]Partner!$A:$A),0),2))


Thanks,
Gaz