Using ISBLANK across multiple cells

[richw85]

Hi all,

I'm sure this is a super easy problem for all you experts out there but I'm trying to figure out:

On Sheet1 using an ISBLANK formula to look at cells F8,G8,H8,I8 and display whatever is written in one of them in cell C4 on Sheet2. Only one of the cells will ever have information in.

Thanks very much in advance for your time and assistance!

 

[taurean]

Welcome to MrExcel.

If only one cell is going to be non-blank then you can use use following formula:
=CONCATENATE(Sheet1!F8,Sheet1!G8,Sheet1!H8,Sheet1!I8)

 

[richw85]

Thanks so much!!