What formula should I use to put a "Yes" in a cell if a matching cell is found in a column range of entries? example:
in cell G12 there is an entry: C12345678
If that is found in a column of entries elsewhere in the same spreadsheet, return "Yes", otherwise return "No"
in cell G12 there is an entry: C12345678
If that is found in a column of entries elsewhere in the same spreadsheet, return "Yes", otherwise return "No"