I could not duplicate your problem when argument LookIn:=xlValues was used.
Apparently your arguments need to be set to accomodate your conditions.

"Aaron" wrote:

Set sc = ActiveWorkbook.Sheets("Region").Rows("4:4").Find(l store)

lstore value is "chicago". When a cell in row 4 has a value of "chicago",
the line works fine. But when a cell in row 4 has a formula that results in
"chicago", sc is Nothing. What am I doing wrong?