Filter and Corresponding Validation List
 

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

Filter and Corresponding Validation List
 

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



--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"sgl" wrote:

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

Filter and Corresponding Validation List
 

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.

"Michael" wrote:

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



--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"sgl" wrote:

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