• crudboy
  • NEWBIE
  • 0 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
I have a list of contact names in an Excel spreadsheet and want to use the Connector to check if these contacts are already in Salesforce.

I figured I could do this using the soql_table function. But instead of typing the name into the formula:
=soql_table("Contact","FirstName = 'Mike' and LastName = 'Stokey' ")
I was hoping to have the formula reference cells in the spreadsheet to find the names. I thought it would look like this:
=soql_table("Contact","FirstName = " & C3 & " and LastName = " & B3 & " ")
But that did not work. It gave me an error message: "unexpected token: Mike"

Can anyone tell me what I am doing wrong?

Thank you.