Excel 2007 Advanced lookup Issue

[purceld2]

I perform an advanced filter on some data and am getting unexpected results (see below). I enter "BK146" along with other lookup criteria but get the results below. For some reason it is bring back all values in the lookup data that begin with BK146.

How can I get around this problem where it just return the value I entered.

Thanks in advance for your help

Excel Workbook
	A	B	C	D	E
1	Name	NBC	Venue	443	4
2	Network Code	Site Code	Venue Code	Venue Type	Status
213	NBC		BK146	Convenience	Live
229	NBC		BK1465	Convenience	Live
230	NBC		BK1466	Convenience	Live
383	NBC		BK1460	Convenience	Live
446
447
448
449	Venue Code
450	BK146
451
452
NBC3

 

[Andrew Poulsom]

For an exact match use the formula:

="=BK146"

 

[purceld2]

Thanks Andrew

 

[purceld2]

Hi There,

I wonder if someone can help the above problem is solved when and avandard filter is manuallly used.

But a past employee uses a FIND Method in the Code which give tme the same problem.

I locate the Find in the code and as advise changed the LookAt from xlpart to xlwhole and I still get the same results

Case 1:
On Error Resume Next
Last = rng.Find(What:="*", _
After:=rng.Cells(1), _
LookAt:=xlPart, _
LookIn:=xlFormulas, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Row
On Error GoTo 0

Can any advise how I can get the code to do an exact match and not bring back the above results.

 

[Andrew Poulsom]

If you want to find an asterisk you need to precede it with a tilde, because it's a wildcard:

Last = rng.Find(What:="~*", _