112x320 x6 worksheets have:

=IF(ISNA(VLOOKUP($A6,OFFSET([PVR.xls]Prices!$A$1,0,MATCH(DH$1,[PVR.xls]Prices!$A$1:$IA$1,0)-1,544,2),2,0)),INDEX(DH:DH,ROW()-1),VLOOKUP($A6,OFFSET([PVR.xls]Prices!$A$1,0,MATCH(DH$1,[PVR.xls]Prices!$A$1:$IA$1,0)-1,544,2),2,0))

Breakdown:

VLOOKUP($A6,OFFSET([test.xls]Prices!$A$1,0,MATCH(DH$1,[test.xls]Prices!$A$1:$IA$1,0)-1,544,2),2,0)) - match by Column A and by Row 1 from another table

-about 26 megs .xls file, any way of reducing the size/faster calculation of this? (112 columns by 320 rows)


Thank You!