Hi,

I would like to compare text within a cell to several other cells and return a 'Yes/No' answer. e.g cell A1 has 'Bob' within, I would like to compare the content cells in B1, D1 and J1 and if the one of these 3 cells has the same content return, 'Same', otherwise 'Investigate'.

Thanks