VLOOKUP & Comparing two sets of data

[JoshYent]

Hi,

I have two lists of part numbers. A is part numbers on eBay, B is part numbers on my website. I have used =VLOOKUP(B2,CurrenteBayItems,1,FALSE) to identify the items that are on eBay, and my website.

My question is, that I would like to identify the part numbers that are NOT on eBay and have them returned over in column E. Which formula would I use to do this?

[FDibbins]

Hi Josh and welcome to the forum

we would love to help you, but 1st, according to forum rule 1, please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertise, and will only open those threads. also, searching for "help" will not turn up too many results that will benefit you, sorry

when you name a thread, think "google". what kind of returns would you expect if you typed that into google?

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[JoshYent]

Okay, I figured it out.

Column C
=IF(B2=A2, TRUE, FALSE)

Column D
=IF(C2=TRUE, "NINJA", A2)

Replaced all Ninja's with a blank, pressed f5 highlighted blanks, then pressed ctrl, and the - symbol. Then shifted cells up.

[FDibbins]

Well done, its always a good feeling when you figure it out for yourself

[JoshYent]

It took me quite some time to realize what I needed to do. I will make sure to format my topic title correct next time. =D