Maybe the Autofilter will do what you want......Data Filter AutoFilter,
then in the dropdown arrow for the name column choose John.....it will
filter and show only the John rows........if you want then click on the 4 in
the age dropdown arrow and it will filter to only the 4yo Johns, etc
etc..........then do Data Filter AutoFilter again to return everything
to normal.....

Vaya con Dios,
Chuck, CABGx3


"New_Man" wrote in message
...
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
.....