Need some function to get cell address if cells with same value scatterd around

Can I use textjoint and if to get cell address of different cells with same values in different rows and columns