Home > Back-end >  How to get coords of cell in google sheets?
How to get coords of cell in google sheets?

Time:02-05

Is there any possibility to get the coords of cell that contains a value ?

example: enter image description here

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),)))

enter image description here

  •  Tags:  
  • Related