Hello.

This checks B, C, D then E and returns the first value, or if nothing is
found it returns nothing. (Enter into cell A1)
=IF(B2="",IF(C2="",IF(D2="",IF(E2="","",E2),D2),C2 ),B2)
--
Kevin Smith :o)


"Dave" wrote:

Hi

I have four columns of data BCDE I want to combine into column A. I want to
say if column B is blank then show column C then if column C is blank then
show column D. It is important that it works in this order as thed ata refers
to dates i.e. last week, last month, last year, over a year.

Can anyone help?

Thanks