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!
Bookmarks