Friday, March 28, 2014

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   Mar-28-2014
post by vangolfer (!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:

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 (!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.