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.

Help.....

If someone out there has a sample S-control I could use, I would like to auto-populate the following.  On the oppty products section; I would like to pull in a value from a custom field within the products object, when the product is added to an oppty. Can this be done with an S-Control?

Any help is appreciated.

Thanks, AC