Pull Column Values from Another Sheet that are in the Current Sheet

[CodeInExcel]

If this has been posted before, and I missed it, I apologize. I did look, but I could have missed in my skimming.

I work with SalesForce A LOT, a WHOLE LOT, and everything is driven off the SalesForce ID. Anyhow, I have several extract files I am combining into one to populate into a new SalesForce Object. Obviously there will be some New items and some combined items, so an UPSERT willbe used via Data Loader. However, for the source CSV files, I am trying to pull the SFIDs that are NOT a match to my current spreadsheet.

So, to MATCH a value, and pull a corresponding reference, that is easy (see below) and this is how I populate the fields that will be record updates

=IF(LEN($B2)=0," ",IFERROR(INDEX('Sheet B'!A2:$A$20,MATCH(TRUE,EXACT($B2,'Sheet B'!B2:$B20),0))," "))

$B2 is the the current column/field of Sheet A that I want match against

Sheet-B Column A is the index location and the value I will copy

Sheet-B Column B is what I am matching my Sheet A '$B2' value against

However, I need to create a second sheet where I do the opposite... how do I also pull any value that IS NOT a match to my current spreadsheet, and only the values that are not a match, e.g. A14 & A15 from Sheet B? These will be my new record entries.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[CodeInExcel]

Thanks... Lesson learned, and I have complied.

[AliGW]

Administrative Note:

One more thing!

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.