Formulas to check two cells in a workbook against two cells in a separate workbook

Hi There, I am doing some Salesforce work in Excel. Essentially I have two workbooks of data. workbook 1 is data I have in Salesforce. workbook 2 is data to be entered into Salesforce.

In each workbook there are two columns (A - Contact Name, B - Firm Name,) What I need to do is almost like a vlookup. I want to run a Formula in Column C of workbook 2 to cross check data in workbook 2.

Essentially if the contacts name and firm name show up in a row together in workbook 1 that matches a row in workbook 2, I will see a note show up (like a vlookup) in that cell in that row in a third column.

I am quite new with excel and I hope I am describing this well. In case not, I have attached two workbooks to describe the situation. Workbook two shows the desired result in Column C and Column D is the explanation of the result.

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

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

(note: this change is not optional )

Also, it often helps if yo could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

No need to repost: just edit your opening thread and go advanced to edit the thread title.