#1
|
|||
|
|||
Lookup and Textjoin help
Hi Guys,
I need to lookup and get multiple values in to one cell using excel function. Sheet 1 have data and column C need to get in sheet 2 column B using functions. Please check the attachment and help me out Thanks Ganesan. G |
#2
|
||||
|
||||
In cell B2:
Code:
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(Sheet1!$C$2:$C$31,Sheet1!$B$2:$B$31=A2,"None"))) |
#3
|
|||
|
|||
Thanks much!!
I got the answer my question... |
#4
|
||||
|
||||
Code:
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(Sheet1!$C$2:$C$31,(Sheet1!$B$2:$B$31=A2)*(Sheet1!$A$2:$A$31="Q1"),"None"))) |
#5
|
|||
|
|||
Thank you so much!!!
|
#6
|
|||
|
|||
Sorry to ask you again
I have tried in real data but cannot pull exactly what i need or correct Can you please check the attached file and correct me? |
#7
|
||||
|
||||
Can you highlight some of what's not 'what i need' and what's not correct?
|
#8
|
|||
|
|||
In sheet 2 Column C2 result should be RB3043, RB3043, RB3043,
But getting only one may be the same value. But i wanted to get these three DO NOT ignore duplicated values and need to get that too. |
#9
|
|||
|
|||
I got the answer when i have removed the UNIQUE function.
thanks very much |
#10
|
||||
|
||||
I had assumed you didn't want repeating values in a list.
So take out the unique bit: Code:
=TEXTJOIN(", ",TRUE,FILTER(Sheet1!$C$2:$C$380,(Sheet1!$A$2:$A$380=A2)*(Sheet1!$B$2:$B$380=B2),"None")) |
#11
|
|||
|
|||
Sorry i forgot to tell you
Anyway thanks much for your time!! |
#12
|
|||
|
|||
Hi I need your help again
Is there any possible to sumproduct the FILTER results numeric value. Please find the attached and let me know we can sumproduct column D in sheet2 |
#13
|
||||
|
||||
For a given member in a given quarter you want separate total Hrs for each Eng?
Not easy using this path. Are you sure it's not a pivot table you want? See attached at cell G1, and another, slightly different arrangement at cell Q1. These take seconds to set up. |
#14
|
|||
|
|||
Hi thanks for the reply
Can we have sum using char(10) as below? if multiple names with multiple values column C column D RB3043 7.5 Pearl15 1 BR715 1 or if same name with multiple values RB3043 290.75 (this is comes from three places) Please advise |
#15
|
||||
|
||||
As I said, not easily. The pivot table gives this information.
What version of Excel are you using? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
Lookup | Tony Singh | Excel | 3 | 03-06-2015 11:03 AM |
Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
Possible Lookup | Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
LookUp | aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |