• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Circuit to search alphanumeric value as well.


New Member
Dear Sir / Madam,

In the file attached, when clicked on the Search button it asks for a circuit ID which is already in "Inventory" Sheet, wherein it just searches only numbers. I need it to search alphanumeric along with symbols too. I request you to help me with the same.

Circuit ID can possibly anything 123/05CD/



New Member
Dear p45cal,

Thank you, This helped in achieving my requirement. Though it was a small change that needs to be removed. It was a game-changer.

Dear vletm,

Thanks for your time in finding a solution, that educated me on TYPE parameter