Clivey_UK:

I tried that already. That only helps if Im trying to get data from
one cell.
So then I tried Nesting that formula like:

=IF(Sheet1!B5="","",Sheet1!B5, IF(Sheet2!B5="","",Sheet2!B5,
IF(Sheet3!B5="","",Sheet3!B5)))

I get too many arguments error

Also tried:

=SUM(Sheet1!B5 & Sheet2!B5 & Sheet1!B5)

That also works if there is a value in any of those 3 cells but if
there isn't it returns value of #VALUE!

I want to make a formula to do this:

IF Sheet1!B5 has data then enter that data to Sheet4!B10
elseif Sheet2!B5 has data then enter that data to Sheet4!B10
elseif Sheet3!B5 has data then enter that data to Sheet4!B10
else output CHAR(160) to Sheet4!B10


Thanks again in advance
monkeyhop


--
monkeyhop
------------------------------------------------------------------------
monkeyhop's Profile: http://www.excelforum.com/member.php...o&userid=34012
View this thread: http://www.excelforum.com/showthread...hreadid=537772