Hi

I'm hoping someone can help me.

I have a spread sheet of people and orders- some with email addresses. I would like to know if there is a formula/function I can use that says:

If the cell in this column (the email column) IS NOT blank, then show the data of the cell - Is it also possible to pull through data across that row, so you pull out the email address and then also customers name?

I have googled and googled and googled and tried IF functions, INDEX functions and filter but just can't seem to make it work.

Thanks