Is there any possibility to get the coords of cell that contains a value ?
assuming you want to search columns A to C. If the formula is on the same sheet, you couldn't search the whole sheet because you would get a circular reference error, but you could put it on a different sheet:
=ArrayFormula(textjoin(",",true,if(Sheet3!A:Z=A2,address(row(Sheet3!A:Z),column(Sheet3!A:Z),4),)))


