Returning Multiple Results with Vlookup

[jeffsmarketplace]

I am trying to return multiple results with the vlookup formula. I
have several occurrences I am finding in a column and I would like to
return each result into the same cell. So as an example:

A B C

1 L1 A J7

2 L1 B J8

3 B2 C J2

4 L1 D J5

So how do I get rows 1,3 and 4 to return column C's values into the
same cell (J7, J8, J5). All I am able to return is 1 value.

=vlookup(value,A1:C4,3,false)

Any help is always appreciated - Jeff

 

[Jim Cone]

http://office.microsoft.com/en-us/excel/HA012260381033.aspx
shows how to return multiple values into multiple cells.
To get them all into the same cell probably requires VBA.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/XLCompanion add-in

..
..
..

"jeffsmarketplace"
<[email protected]>
wrote in message
I am trying to return multiple results with the vlookup formula. I
have several occurrences I am finding in a column and I would like to
return each result into the same cell. So as an example:

A B C

1 L1 A J7

2 L1 B J8

3 B2 C J2

4 L1 D J5

So how do I get rows 1,3 and 4 to return column C's values into the
same cell (J7, J8, J5). All I am able to return is 1 value.

=vlookup(value,A1:C4,3,false)

Any help is always appreciated - Jeff