Ok, so I am trying to search for a name from one cell in a column on another spreadsheet. They are not exact matches because one spreadsheet has the middle initial and the other doesn't.
So trying to search a column another spreadsheet for partial text in one cell and return "yes" if it's found and "no" if it's not found. I have searched the forums and tried many of the similar solutions, but haven't been able to get anything to work.
The number of cells in my search column will change. I tried the formulas below and none of them have worked. I am open to any suggestion even if I need to create a macro to accomplish this.
=SEARCH(MID(F2,1,15),'[PCI Training.xls]CSE Training'!$C:$C)
=IF(ISNUMBER(SEARCH(MID(F3,1,15),'[PCI Training.xls]CSE Training'!$C:$C)),"Yes","No")
=IF(ISERROR(MATCH(SUBSTITUTE(REPLACE(F5, 1, FIND(CHAR(15), '[PCI Training.xls]CSE Training'!$C:$C), ""), CHAR(15), ""),'[PCI Training.xls]CSE Training'!$C:$C, 0)), "Yes","No")
So trying to search a column another spreadsheet for partial text in one cell and return "yes" if it's found and "no" if it's not found. I have searched the forums and tried many of the similar solutions, but haven't been able to get anything to work.
The number of cells in my search column will change. I tried the formulas below and none of them have worked. I am open to any suggestion even if I need to create a macro to accomplish this.
=SEARCH(MID(F2,1,15),'[PCI Training.xls]CSE Training'!$C:$C)
=IF(ISNUMBER(SEARCH(MID(F3,1,15),'[PCI Training.xls]CSE Training'!$C:$C)),"Yes","No")
=IF(ISERROR(MATCH(SUBSTITUTE(REPLACE(F5, 1, FIND(CHAR(15), '[PCI Training.xls]CSE Training'!$C:$C), ""), CHAR(15), ""),'[PCI Training.xls]CSE Training'!$C:$C, 0)), "Yes","No")
