hi people i am working on a database. i want to use the vlookup for example..

Names age Vlookup john age
john 1 1
bill 2 4
pat 3 5
john 4 7
john 5
bill 6
john 7

I want all the john age to be displayed, my database is over a thousand
rows, so i was wonder if i can just select the whole entire row like B:B and
it find all the ages for john only.. help plz and Thank you for your time ....