Search from Google sheets

Hi I am just getting started and having an issue. I have google sheets database that I have imported with an API. The google sheet has addresses in it. I want to be able to type in the numerical number of the address and any address with that address show up. For example, if I type in 414 in the search bar any address with 414 shows up 414 Main St and 414 Berkley Ct. I can’t figure this out…