I am using a "Hlookup" formula in an "if" formula and so the formula in the
cell is quite large. I want to repeat this formula so I can lookup for values
in several files (more than 10) how can I use the lookup formula to search
values in several files at a time and then do the sum of these values and put
it in one cell.

Thanks in advance
--
Shi Gharib