Excel concatenate function with multiple conditions

0 votes

I have the following in the first 3 columns of my sheet in excel:

Results table. C3 is where I want the concatenation done

I also have the following table:

Table 69

Now I am trying to use concatenate to retrieve the items from table 69 using the following conditions: Spec = the value in B1 (Yellow in the first photo) Slot = each of the values in column A (A2:A18)

this is the formula I have in C2:

=CONCATENATE(IF(AND(Table69[Spec]=$B$1;Table69[Slot]=A2);Table69[Item];"")& ",")

Can anybody help me with this as this formula for the moment is returning as if there were no values?

Dec 9, 2022 in Others by Kithuzzz
• 28,700 points
79 views

1 answer to this question.

0 votes

Use this :

=TEXTJOIN(", ";TRUE;IF((Table69[Spec]=$B$1)*(Table69[Slot]=A2);Table69[Item];""))
answered Dec 10, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 53,160 points
130 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 53,160 points
174 views
0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 53,160 points
112 views
0 votes
1 answer

Repeated excel rows based on a cell with multiple values

You can use this query: let ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
• 53,160 points
113 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
530 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
477 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,499 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,010 views
0 votes
1 answer

Excel sumif function with conditions

Try SUMIFS. =sumifs(table1[sum time (sec)],Table1[type],1, Table1[Date],K3, Table1[Time],K4, Table1[Sum Time ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 53,160 points
103 views
0 votes
1 answer

Excel If Functions with Multiple Conditions

Use this: =IF(C3<=0,"Green",IF(C3<500,"Silver",IF(C3<=1499,"Gold","Platinum"))) I added <=0 just in case you have ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 53,160 points
54 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP