I'm not sure if this is achievable, but hopefully so.

I'm using two IF's in one formula (lets say in A1) that is searching through a range of data on another worksheet. If both conditions are met, it returns an email address, and FALSE if False.

Basically, I'd like the formula to skip the false and only fill trues, meaning that when I auto filled from A1 I would have a nice column full of email addresses.

At the minute it just looks like a column full of Falses mixed with the odd email addresses.

I know I can filter out the falses, but I would like to make a macro on this one.

Any help (or indication that it can't be done) would be grand!

Thanks all,

Si