I've never used the <Ctrl <Shift <Enter before. Is that something I press
once, then enter, or enter the data, then press it? Either way I can't seem
to get it to add the curly parentheticals...

"RagDyer" wrote:

You could try this formula using resident XL functions:

Names in Column A
Companies in Column B

Name to lookup in C1

Enter this array formula in D1:

=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$ 1:$A$30)),ROW(A1)))

Must be entered using <Ctrl <Shift <Enter
Which will *automatically* enclose the formula in curly brackets,
Which *cannot* be done manually!

Drag down to copy as many rows as you anticipate you might need in order to
return all the possible valid returns.
When you see a #NUM! error, you know that all instances are returned.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Chris_Hatch" wrote in message
...
Alan,

I get a #NAME? error when I put in your formula. I noticed you used
"vlookups" instead of "vlookup" and you removed the "false" qualifier. Is
that part of the solution?

When I do =vlookup(Jim,range,2,false) it returns Dell. I want to the next
time I put a vlookup command to return Toshiba and then Lenovo respectively.
The way I have it now just keeps returning HP. How do I tell it to go to
the
next Jim's column two value?

"Alan Beban" wrote:

Chris_Hatch wrote:
I want to return the 2nd field for Jim in a single list:

Jim Dell
Jeff HP
Carl Compaq
Jim Toshiba
Carl Sony
Jim Lenovo
Jeff IBM

I want to pull Jim's accounts to another worksheet:

HP
Toshiba
Lenovo

When I use vlookup, it just returns HP and stops. How do I tell it to
return the next instance of Jim?

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook you can
array enter

=VLookups("Jim",dataRange,2)

Alan Beban