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.

http://office.microsoft.com/en-us/as...260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

I keep getting a #REF error when tring to reference another sheet.


"Niek Otten" wrote:

http://office.microsoft.com/en-us/as...260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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