Use of IF to copy specific cells in a range

Hi,

I am using the below formula to copy data from one cell to another if a certain cell is populated:

=IF('Sheet2'!E6=""," ",'Sheet2'!B6)

The desired destination is a cell in Sheet 1 (If this makes a difference)

Basically, I am trying to make it so this will work across multiple cells.

Desirably this would be =IF('Sheet2'!E6:E8=""," ",'Sheet2'!B6:B8) but this isn't working.

Can anyone advise of a usable formula?

Thanks

Originally Posted by Special-K

Just take your original formula and copy it to the other cells, the formula will adjust accordingly.

Sorry, I should have made myself clearer.

I want to be able to use the IF across a range of cells but have this data collate into just one cell.

E.g. =IF('Sheet2'!E6=""," ",'Sheet2'!B6) OR =IF('Sheet2'!E7=""," ",'Sheet2'!B7) and so on.