have tried this formula

=IF(ISNUMBER(MATCH("TOM LEE JONES",F3:F29,0)),"OK", "Not OK")


It works however i need to get the addresses of all the celss having similar data...
Is that possible..

Col A Col B
Tommy lee jones
Tommy lee jones -b2


Tommy lee jones-b5

the function shud give me the addresses of both the cells which contain the data in A2.