basically i got a database that i have made user forms for data entry and i want to use a form which will retrieve the records based of a criteria... i have tried vlookup but it will only retrieve the first record example...

name ¦ surname ¦ age ¦
john ¦ doe ¦ 58 ¦
bob ¦ smith ¦ 24 ¦
john ¦ doe ¦ 23 ¦

now what i need is a function that would return both john doe records instead of just the first one if i searched by the surname.

if any1 has a answer it wud be most appreciated