Error trying to find value in column

[sharky12345]

I have this formula which I use to find if a value exists in a range;

For Each cell In Sheet14.Range("B4:B23")

Set found = Sheet4.Columns("N").Find(what:=cell.Offset(0, 15), LookIn:=xlValues, LookAt:=xlWhole)

If found Is Nothing Then
Exit Sub
If cell.Offset(0, 2) = "Area" Or cell.Offset(0, 2) = "Sub" Or cell.Offset(0, 2) = "Visit" Or cell.Offset(0, 2) = "Office" Then

So what this is supposed to do is search column N to see if the value in column Q is there, and if it is then run the next part;

If cell.Offset(0, 2) = "Area" Or cell.Offset(0, 2) = "Sub" Or cell.Offset(0, 2) = "Visit" Or cell.Offset(0, 2) = "Office" Then

The issue I'm having is that it is not finding the value, even though it is there and exists.

Now I don't know if this makes a difference, but the values being searched is a numeric one which is actually a formula result in column N and Q - would this make a difference?

 

[steve the fish]

Is Sheet4 and Sheet14 intentional?

 

[sharky12345]

What an idiot - completely missed that....

Thanks - working now!