Multiple results of Vlookup in one cell

[Murtaza]

Dear Experts:

How can I retrieve multiple occurances of lookedup value in one cell??
I want to retrieve thru formula multiple product sales in a given date.

Jan-1 Product 1
Feb-15 Product 4
Jan-5 Product 3
Feb-15 Product 1
Feb-15 Product 2

so results should be :
Lookup value: Feb-15
Results: "Product 4, Product 2, Product 1" as a string in one cell

Is it possible using a Vlookup or any other combination of formula

Please help
Murtaza

 

[Niek Otten]

Hi Murtaza,

Look here to get multiple results:

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

Then you can concatenate the results in one cell with a formula like

=A1&"', "&A2&", "&A3 etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Dear Experts:
|
| How can I retrieve multiple occurances of lookedup value in one cell??
| I want to retrieve thru formula multiple product sales in a given date.
|
| Jan-1 Product 1
| Feb-15 Product 4
| Jan-5 Product 3
| Feb-15 Product 1
| Feb-15 Product 2
|
| so results should be :
| Lookup value: Feb-15
| Results: "Product 4, Product 2, Product 1" as a string in one cell
|
| Is it possible using a Vlookup or any other combination of formula
|
| Please help
| Murtaza
|
|

 

[Murtaza]

Thanks, I have posted to this forum after reading this good article...nicely
done

But Niek, but according to this article, you have to copy/paste array
formula to many cells in order to get multiple results.

Do we have any formula which do this Concatenate in a single cell?

 

[Niek Otten]

Yes, that is the formula I gave in my initial reply

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Thanks, I have posted to this forum after reading this good article...nicely
| done
|
| But Niek, but according to this article, you have to copy/paste array
| formula to many cells in order to get multiple results.
|
| Do we have any formula which do this Concatenate in a single cell?
|
|
| | > Hi Murtaza,
| >
| > Look here to get multiple results:
| >
| > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
| >
| > Then you can concatenate the results in one cell with a formula like
| >
| > =A1&"', "&A2&", "&A3 etc
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| | > | Dear Experts:
| > |
| > | How can I retrieve multiple occurances of lookedup value in one cell??
| > | I want to retrieve thru formula multiple product sales in a given date.
| > |
| > | Jan-1 Product 1
| > | Feb-15 Product 4
| > | Jan-5 Product 3
| > | Feb-15 Product 1
| > | Feb-15 Product 2
| > |
| > | so results should be :
| > | Lookup value: Feb-15
| > | Results: "Product 4, Product 2, Product 1" as a string in one cell
| > |
| > | Is it possible using a Vlookup or any other combination of formula
| > |
| > | Please help
| > | Murtaza
| > |
| > |
| >
| >
|
|

 

[Murtaza]

Can anyone pleaes tell me how to use the Function mentioned on this website:
http://www.sulprobil.com/html/vlookupall.html

 

[Niek Otten]

================================================
Pasting a User Defined Function (UDF)
Niek Otten, March 31, 2006

If you find a VBA function on the Internet or somebody mails you one, and you don't know how to implement it, follow these
steps:

Select all the text of the function.
CTRL+C (that is, press and hold down the CTRL key, press C, release both). This a shortcut for Copy.
Go to Excel. Press ALT+F11 (same method: press and hold the ALT key, press the F11 key and release both). You are now in the
Visual Basic Editor (VBE).
From the menu bar, choose Insert>Module. There should now be a blank module sheet in front of you. Click in it and then
press CTRL+V (same method.). This a shortcut for Paste. You should now see the text of the function in the Module.
Press ALT+F11 again to return to your Excel worksheet.
You should now be able to use the function as if it were a built-in function of Excel, like =SUM(..)
================================================



--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Can anyone pleaes tell me how to use the Function mentioned on this website:
| http://www.sulprobil.com/html/vlookupall.html
|
|
|
|
| | > Hi Murtaza,
| >
| > Look here to get multiple results:
| >
| > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
| >
| > Then you can concatenate the results in one cell with a formula like
| >
| > =A1&"', "&A2&", "&A3 etc
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| | > | Dear Experts:
| > |
| > | How can I retrieve multiple occurances of lookedup value in one cell??
| > | I want to retrieve thru formula multiple product sales in a given date.
| > |
| > | Jan-1 Product 1
| > | Feb-15 Product 4
| > | Jan-5 Product 3
| > | Feb-15 Product 1
| > | Feb-15 Product 2
| > |
| > | so results should be :
| > | Lookup value: Feb-15
| > | Results: "Product 4, Product 2, Product 1" as a string in one cell
| > |
| > | Is it possible using a Vlookup or any other combination of formula
| > |
| > | Please help
| > | Murtaza
| > |
| > |
| >
| >
|
|