Formula required for looking up and copying values

[lemontwist71]

Help please

I want a formula / function that looks at a cell.... and if there is text in it, it then copies the text to the previous column, same row...... but if the original cell is blank then it takes no action.

Hope this is clear

Thank you for your help.[/FONT]

[Blake 7]

See attached spreadsheet...........

This is the formula

=IF(B1="","",B1)

Is this what you are after?

[lemontwist71]

Thanks for your reply.....please see my attached spreadheet.....

I would like the formula to look in C2 and as its blank to put the text from B2 into D2. When looking at cell C4 it has text so this needs to be copied to D4 ….. Basically I need all the surnames in one column.

If you can see another way to do this then that will be great!

I hope you can help.

Thank you

[Blake 7]

Hi LT.

In D2:

=IF(OR(C2="",B2=""),B2,C2)

Copy down

Is this what you are after?

Cheers

[lemontwist71]

Oh Excellent! Thankyou so much!