I've created a spreadsheet for finding pinball machines. You can enter in one lot of information or you can enter in multiple fields to drill down the search. The data is coming from the "Data" tab.

When someone enters a postcode, I'd like it to search for "nearby" postcodes by returning results with a +/- 10 (or 20) number variance. So if someone enters 2050, I'd like all results ranging from 2040-2060.

I can't actually conceptually think of how this can be done in excel, the main train of thought I had was somehow getting the cell to host multiple data? So if the user enters 2050 it will magically turn that field into (2040, 2041.....). I'm not attached to the idea, any solution or assistance would be awesome :0

Here's a link to the spreadsheet:
https://docs.google.com/spreadsheets...it?usp=sharing

Thanks !!!!