search all of column C on page 1 - for the value thats on Page 2 in cell D2 only ?
if so then for the whole column and not a range in the column
=IF(ISERROR(MATCH(D2,'Page 1'!C:C,0)),"","X")
search all of column C on page 1 - for the value thats on Page 2 in cell D2 only ?
if so then for the whole column and not a range in the column
=IF(ISERROR(MATCH(D2,'Page 1'!C:C,0)),"","X")
Last edited by etaf; 05-24-2013 at 08:18 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks