you need to give more info and sample sheet ideally. If you type a value to filter by and you "know" that value should exist there are a number of possibilities including: non-visible characters, you are searching for a number but the cells are actually text, visible characters are sometimes mistaken for other characters (e.g. - is different than –)