Concatenate while using index match and if statements

[andrekel]

Hello forum,

I have a workbook, that I use to import data into our ERP. I have 3 columns(E,F,G) that I will input a number into. I want to concatenate the 3 columns in Column H. While inputting nothing if the column is empty.

AssortmentTiers-Products_Warehouses.xlsx
	E	F	G	H
1	Depot 1	Depot 2	Depot 3	Warehouses/ID
2	123	114	115	__export__.stock_warehouse_51_ced98dd7,,115
3
Sheet2

Cell Formulas
Range	Formula
H2	H2	=(INDEX(warehouses!$A:$A,MATCH(E2,warehouses!$B:$B,0)))&IF(F2<>"",",",INDEX(warehouses!$A:$A,MATCH(F2,warehouses!$B:$B,0)))&IF(G2<>"",","&G2,"""""")

Not getting the results, I want. It is not pulling in the 2nd index match. The delimiter(comma) shows but the index-match is blank. When I remove the delimiter it works, but I need the comma to make sure the import works correctly.

Here it is with the delimiter(comma) removed.

AssortmentTiers-Products_Warehouses.xlsx
	E	F	G	H
1	Depot 1	Depot 2	Depot 3	Warehouses/ID
2	123	114	115	__export__.stock_warehouse_51_ced98dd7__export__.stock_warehouse_38_4318f5b3,115
3
Sheet2

Cell Formulas
Range	Formula
H2	H2	=(INDEX(warehouses!$A:$A,MATCH(E2,warehouses!$B:$B,0)))&IF(F2<>"",INDEX(warehouses!$A:$A,MATCH(F2,warehouses!$B:$B,0)))&IF(G2<>"",","&G2,"""""")

As you see it works like it should, but the comma is missing.

Where am I going wrong. Any help would be greatly appreciated.

Thank you,

André

 

[Marcelo Branco]

Missing &

I think it should be
=IF(E2<>"",INDEX(.....),"")&IF(F2<>"",","&INDEX(.........),"")&IF(G2<>"",","&G2,"")

M.