It allows me to bring up the screen to look for something but when I hit the button to search it comes back not found and I know it is in the sheet somewhere.
Hit Options>> and fiddle around with the choices. You can also hit "Format...", go to the cell you know that the result is in to select. Maybe there are blank spaces that are affecting the find.