lookup value

[Shi Gharib]

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

 

[ryguy7272]

This may help you:
http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1

http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1


Regards,
Ryan---