VLookup returning more than one Row of information

[Kharum]

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.

 

[Niek Otten]

http://office.microsoft.com/en-us/assistance/HA012260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.