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