Hi JJFJR,

I entered "=Rack 1" into my search criteria area and no hits came up after
hitting the search button. Any other ideas are appreciated.

My suggestion was:

="=Rack1"

Note the initial =

---
Regards,
Norman



"jjfjr" wrote in message
...
Norman;

Thanks for the reponse. I tried your I idea and it got no hits. My search
is
triggered by some VBA code attached to my search button as follows:

Worksheets("Data").Range(DataRng).AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Worksheets("Results").Range(CritRng ),
CopyToRange:=Worksheets("Results").Range(ResultsRn g), _
Unique:=True

I entered "=Rack 1" into my search criteria area and no hits came up after
hitting the search button. Any other ideas are appreciated.
--
JJFJR


"Norman Jones" wrote:

Hi JJFJR,

Try:

="=Rack1"


---
Regards,
Norman


"jjfjr" wrote in message
...
Hi;

I have a two sheet workbook. One sheet allows for the entry of search
criteria in the upper half and the search results in the lower half.
The
other sheet contains the records that are searched.

I have a situation where in one field called Location, there are
similar
values such as Rack 1, Rack 11, Rack 12, etc. If I want to search for
rows
that only have Rack 1 in the Location and I put in Rack 1 into my
search
field, rows that have Rack 1, Rack 11, etc. come up as hits. Is there a
wilcard or other character that allows me search for a speciific value
like
"Rack 1" ? By the way I tried putting Rack 1 in quotes and itr did not
help.
Any assistance is greatly appreciated.
--
JJFJR