Formula identifying if cell contents is present in a column

**dforte** · 03-18-2011, 05:38 PM

In column A I have a list of unique IDs. In column B I have another list of Unique Id's. I want to create a formula that produces an indicator in column C if the contents in column B is present anywhere in column A.

Does that make sense?

**6StringJazzer** · 03-18-2011, 05:41 PM

Put in C1 and copy down as many rows as necessary

=IF(ISERROR(MATCH(B1,A:A,0)),"not present","PRESENT"))

**dforte** · 03-18-2011, 05:48 PM

Would this work if I were to have the two unique IDs on different sheets?

**6StringJazzer** · 03-18-2011, 05:56 PM

This formula is perfectly happy to work across sheets (or even different workbooks). You just have to change the reference "A:A" to include the correct sheet reference. You can type it, or highlight A:A and while it's highlighted simply click on the tab for the other sheet and highlight the column of IDs, then hit Enter.