Sort column to match another column and show differences

[Laai]

Hey,

I need some help with a (surely for the most visitors here) relatively easy problem.

I have a table that I've created with vlookup from two sheets. It looks as follows:

Item1	Item3
Non-existent	Item1
Item3	Non-existent
Item4	Item2

I need to match items from A to B and to show where there is no match:

Item1	Item1
Non-Existent	Item2
Item3	Item3
Item4	Non-Existent

Any idea on how to do this. Bare in mind that I've just started to work in (mostly Google Sheets) and a little bit in Excel. Thanks!

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. Why? Because I do not know whether "non-existent" means a blank cell... also I do not know how/where you expect the results to appear

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

[Laai]

Hey,

Thanks for the swift reply. I did read the yellow sign, hence why I did not post a screenshot, but thought it would be clear if I just made a quick table here. Obviously, I was wrong, sorry for that.

Will try to update with the correct data...

[Glenn Kennedy]

Not wrong at all.... but it just wasn't clear to little old me exactly what you wanted. Sometimes my stupidity amazes me!!

[Laai]

Not wrong at all.... but it just wasn't clear to little old me exactly what you wanted. Sometimes my stupidity amazes me!!

Ah no worries - thanks for the help. I hope the attachment is now there. Thanks in advance!

[Glenn Kennedy]

Try this:

=IF(ISNUMBER(MATCH(F2,$B$2:$B$7,0)),A2,"")

depending on your locale, you may need ; instead of ,