2 parts : Copy info based on match

This is a 2 parter, but if someone can at least help with the first part, I'd greatly appreciate it.

If Sheet2 A1 is found anywhere in Sheet1 Column A, leave cell blank. If it is not found, fill cell with Sheet2 B1.


Second part: I'm going to copy this downward a couple thousand rows, and it will have a lot of holes, so I'd like to do something like importrange to copy that column to another only when the cells are populated.

Cross-posted here:

http://www.mrexcel.com/forum/excel-q...ml#post4362134

I didn't. I thought you gave up on me. I've been trying to work around the same problem with more hidden tables and steps.

I see that now. I actually have all of the ESNs from all of the necessary tables in a column on a different tab in the ESN Sheet. That column is Sheet1 Column A from the post on this thread. I have this on the same tab as the new row I created, and I feel like I'm almost there, but I'm not sure what I've got wrong.

=IF(ISNA(MATCH(DONTEDIT!A:A,Shipped!G5,0)),Shipped!G5,"")

I'd rather simplify it, but I could go either way.

Oh. Yeah. I misunderstood your question.

All I want is for the unmatched ESNs to show up with Date - ESN - Model somewhere organized and without blank cells. Doesn't matter if it looks pretty working up to it, because the finished columns are going to be imported to a whole other sheet when they look right.