Text cell in IF function

[strixy]

I have a multiple IF function that works like a charm for numbers across a couple of spread sheets. I use it to merge data from 5 sheets into one final sheet. Each sheet is the same so the references are all the same.

IF the 'SHEET1'!CELL has any value, then it puts that value in 'FINAL'!CELL.

The problem I'm having is that I need that IF function to do it's thing for cells with text.

This is the one I have that works great for numbers. When I try to use it on cells with text I get an #VALUE! error.

Please Login or Register  to view this content.

[daddylonglegs]

Try along these lines

=IF('DAN-WORKING'!P3<>"",'DAN-WORKING'!P3,IF('DEREK-WORKING'!P3<>"",'DEREK-WORKING'!P3,IF('EAMONN-WORKING'!P3<>"",'EAMONN-WORKING'!P3,IF('RICKY-WORKING'!P3<>"",'RICKY-WORKING'!P3,"CHECK REFERENCE"))))

[strixy]

Yes, that did the trick! Thank you very much.