yogi_Mark Y In Columns C And D If Entries In Sheet1 Exist In Sheets 'AHREfs Links' and 'OSE Links' Respectively

                                         Google Spreadsheet   Post  #1579
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-28-2014
post by vangolfer (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/B1t9CwcYUco)
Referencing a cell within a query (find a duplicate between sheets)

I have a list of links from one source, and I'm trying to see if each one already exists in my lists from other sources: https://docs.google.com/spreadsheet/ccc?key=0Ait1Kc7l3ZVIdGZuM3h2TXg1Z1kzR3p3cHhEWTltSUE&usp=sharing

I *think* the best way to do this is with a QUERY. I'm able to find a hard-coded string, but when I try to reference a cell in my query, it doesn't work. Based upon another discussion (https://productforums.google.com/forum/#!topic/docs/M3y6VJcaRio )

I've tried this:

=QUERY('AHREFs Links'!$A$2:$A$900,"select * where A = " & A2, "")

(and of course countless other combinations) But no luck.

------------------------------------------------------------------------------------------------------------------------------------------------------