Hi everybody,
I have 7 lookup values on each row from columns Z:AF, and I want the corresponding value of Column A of File BBL220.xls that are on column C and D of that same file. I was able to do it like this [The sum of each corresponding value on one column at a time]:
=(SUMPRODUCT(--(ISNUMBER(MATCH([BBL220.xls]Jun25!$A$8:$A$110,Z24:AF24,0))),INDEX([BBL220.xls]Jun25!$A$8:$D$110,,3))+SUMPRODUCT(--(ISNUMBER(MATCH([BBL220.xls]Jun25!$A$8:$A$110,Z24:AF24,0))),INDEX([BBL220.xls]Jun25!$A$8:$D$110,,4)))/2000
However, this is when the file is opened, but the file is so well buried in directories that when I close the file, the formula is just a mess and is really huge. I am affraid that as the file gets even more buried in years to come, this formula may exceed the character limit.
Any ideas on how to add column C & D without having a formula for each? I know I can cut it but I prefer everything on one cell.
Thanks a ton
Bookmarks