Filter and Corresponding Validation List

[sgl]

I have the following list of product codes which I need to filter only for
codes ending with the last three 0's (zeros) and then apply a dropdown
validation list of the corresponding Product Name. I have tried using wild
cards such as * and ? but I cannot seem to get it to work.

Prod
Code Product Name
----------------------------
1000 One
1100 One Onehundred
1200 One Twohundred
1300 One Threehundred
2000 Two
2100 Two Onehundred
3000 Three

Can someone offer some assistance on this
Thanks in advance/sgl

 

[Michael]

If Mid(A2,len(A2)-2,250)="000" then
Datavalidation goes here
End If

 

[sgl]

Thanks you for your assistance. The problem was that I have found that
wildcards do not work if cell is formated as a number. If you format cell as
text and enter a number then the wildcard will work and you can filter.