I know this has to be easy but for the life of me I can't figure it out. I
have a Vlookup statement...IF(ISNA(VLOOKUP($A2,COREDB,8,False)),"
",VLOOKUP($A2,COREDB,8,false))...it works but it only returns information
from one entry. The number in cell A2 appears in the database "COREDB" more
than once and I wouold like to have it return the entire row of information
foe each time the number appears. ex.

A B C D
1234 yes no yes
1234 no no no
1244 nju ijn noio

I would like the lookup to return both rows of 1234. How can I do this?
Please help.