I'll try it again;

I have forty worksheets where I'm putting the names of different bowlers
(location of bowlers are in c7:c46 on each sheet). If a bowler is absent I
use "non bowler".

I'm trying to find a formula that will look at all forty sheets and report
back the active bowlers by not including the "non bowlers" found on most of
the sheets.
--
Regards,
**newdeas**<<




"newdeas" wrote:

I'm trying to get information from the same colums located on multiple
(40)worksheets. I've adjusted the below formula many times using the =if, and
& or but I'm getting "value", "non bowler", or it's skipping some of cell
contents(see below):
=IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7)

I'm stuck! Can anyone help me out with this one?
--
Regards,
**newdeas**<<