Hi
download Morefunc.xll (http://longre.free.fr/english)<and have a look
at THREED for this purpose

--
Regards
Frank Kabel
Frankfurt, Germany

"R. Hale" schrieb im Newsbeitrag
...

Hello all,

I am in a bind. I need to discover a function to look at a column in
a
series of worksheets to look for a value. If that value is found
then
I need the function to return in data in two other cells. For example
in need the function to look in column C for the value X, if Value X
is
found then I need the values in column A and B to be returned in
another
worksheet. The reason I am need this function is I am trying to cut
down on human error, even though not brain science, on this project.
Please tell me there is function out there that can do this. Thanks
for any information

R. Hale


--
R. Hale
---------------------------------------------------------------------
---
R. Hale's Profile:
http://www.excelforum.com/member.php...o&userid=16823
View this thread:
http://www.excelforum.com/showthread...hreadid=320159