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.
Bookmarks