Need formula to enter specific text if a column contains other specific text

**sugarmags74** · 12-03-2012, 08:44 PM

I am creating a small database where the first tab lists a series of documents that will be reviewed in one column (Jones1, Jones 2, etc.) and presents a summary status. If the document meets certain parameters, an entry will be made on a second sheet containing relevant data from that document by the reviewer, and the reviewer will enter the document name (Jones1) in a corresponding column. If it doesn't meet the parameters, there will be no corresponding entry on the second sheet. I basically need a formula to populate a column in the summary spreadsheet with a "Y" or "N" depending on whether that doc name appears in the corresponding column.

I am an absolute novice when it comes to formulas, so I hope my question makes sense. Appreciate any help!

**6StringJazzer** · 12-03-2012, 11:14 PM

If both tabs list the documents in column A starting in row 2 (assuming you have a row of headers) then put this formula in the desired column in row 2 of the summary sheet and copy down:

=IF(ISERROR(MATCH(A2,Sheet2!A:A,0)),"N","Y")

A2 is the cell containing the document name in the summary sheet, and Sheet2!A:A is column A containing the document names in the second sheet. Replace "Sheet2" with the actual name of the second sheet.

**sugarmags74** · 12-04-2012, 02:22 PM

Thank you so much - I adjusted the formula to correspond to different columns to account for the order I set it up in, but it worked perfectly. Always wonderful to learn something new!