Finder in Excel

[slora00]

Hello community, I hope you're all doing great.

I need to make a "finder" tool on Excel, that basically, searches through a pretty simple and small database (only 6 columns x 15k rows), and return every possible result based on what's being searched. So, the database has ID, NAME, LAST NAME, GENDER, DOB and AGE as columns, and it's on sheet "Data". On sheet "Finder", I need to build something (it could be with formulas or macros, whatever works best), that if I'm searching by ID, and I miswrite 3 out of the 12 numbers, the tool still shows me all the possible results. For example, lets say there are 4 people whose IDs end in 1234, and the search I try to do ends on 1235, then, those 4 people should show up on the results.

Let me know if you have any idea of how this could be done.

 

[JEC]

If D1 is your input cell

Sub jec()
On Error Resume Next
Range("a1").CurrentRegion.AutoFilter 1, Filter([transpose(if(left(right(d1,4),3)=left(right(a2:a5,4),3),a2:a5))], False, 0), 7
End Sub

Book4
	A	B	C	D
1	nmr	name		blabla1235
2	1234	a
3	1235	b
4	1234	c
5	5236	d
Sheet1

 

[slora00]

Excuse me but I don't get what does this code do.