I forgot to mention the colum range is c7:c46
--
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**<<