I have a string for example "NAM-1" in a cell in, say sheet 1. I want to
search this string in sheet 2. However sheet 2 does not have "NAM-1"; instead
it has "NAM". Is there a way to do something like Cells.Find("NAM-1") in
sheet 2 and do a partial match with "NAM".

It is possible to find "NAM" within "NAM-1", but is it possible other way
round. The method should be able to give me the cell with the string "NAM".

Thanks
Farooq