How to solve this

[Donald Genes]

Using any method you wish, from G2:K8, return the cell addresses in order from left-to-right, row by row, for the number 6. Please have the results returned in a single column with only 1 cell address per cell, and don't include empty/blank results.

 

[arthurbr]

Hi
is this some kind of homework?

 

[Donald Genes]

Not home work per se, trying to help a friend who was sent this before he can go for interview?

thinking of using Index + match function