meldarionqeusse
6/26/2018 - 12:56 PM

Find text in range of cells and return cell if not leave empty

if column contains text which is equal to text in cell A2 then it returns A2

Paste this in cell A2 and write {=IF(ISNUMBER(MATCH(A2,A3:A13,0)),A2,"")} in cell A1



1C8109	1C8160	1C8296	1C8507	1C8627	1C8722	1C8727	2C7461
1C8109							
	1C8160	1C8296		1C8627	1C8722	1C8727	2C7461