lookup value
 

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

lookup value
 

This may help you:
http://www.microsoft.com/office/comm...=en-us&m=1&p=1

http://www.microsoft.com/office/comm...=en-us&m=1&p=1


Regards,
Ryan---


--
RyGuy


"Shi Gharib" wrote:

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