Vlookup, if and concatenate matching criteria/designator

[SamCV]

Hello to all...

I have in a table the following information starting in G36 (Designator) and Box Serials (H36) as shown in the Table below:

Designator

Box Serials

1	KVZV, XNHM, QJFW, GFVN,
1	PBMG, BXQD, LLRZ, CGJNL,
2	ZDTN, WPLS, MZGC, HKDT,
1	QFXB, BMVV, VGHF, VXPK,
2	ZFTN, RCJD, DCFV, GXRX,
1	SXDX, CPSM, KXTK, PHCX,
2	QVJT, LWCK, TRWL, LPZQ,
1	PTRX, CPKD, LXJC, KTNV,

While reviewing this, I have in cell G63 the Criteria Value (1) and in cell G64 the criteria value (2).

Can anyone help me to find a formula to concatenate the box serials accordingly with the Criteria/Designator value (1 or 2) in cells H63 and H64 respectively??

I've been doing some searching, but not close to what I am looking for. I know about the Morefunc add-in, but I can not install it in my office computer. I can not also record UDF/VBA codes, due security excel settings and because the original file is on a distribution list, that will imply to attach also the UDF/VBA code in the e-mail. These are my reasons to avoid morefunc add-in and VBA/UDF codes.

Hope somebody can help me with my thread. I have received help in other threads and everyone kindly helped me.

Best regards and please have a great day.

Samuel Cruz.
Matamoros, Mexico.

[mikeTRON]

Post a sample workbook instead of the above and that might help.

[SamCV]

Concatenate If Match Designator.xlsx

Post a sample workbook instead of the above and that might help.

Hello!!!

Thank you for the prompt answer. Attaching file with expected out comes.
For review.

Best regards!!!

Samuel Cruz.
Matamoros, Mexico.

[FDibbins]

What would your expected outcome be?

[FDibbins]

If you dont want to/cant use VBA, then try this using 2 helper columns (I used I and J...

	G	H	I	J
36	Designator	Box Serials
37	1	KVZV, XNHM, QJFW, GFVN,	KVZV, XNHM, QJFW, GFVN,	0
38	1	PBMG, BXQD, LLRZ, CGJNL,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL,	0
39	2	ZDTN, WPLS, MZGC, HKDT,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL,	0 ZDTN, WPLS, MZGC, HKDT,
40	1	QFXB, BMVV, VGHF, VXPK,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL, QFXB, BMVV, VGHF, VXPK,	0 ZDTN, WPLS, MZGC, HKDT,
41	2	ZFTN, RCJD, DCFV, GXRX,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL, QFXB, BMVV, VGHF, VXPK,	0 ZDTN, WPLS, MZGC, HKDT, ZFTN, RCJD, DCFV, GXRX,
42	1	SXDX, CPSM, KXTK, PHCX,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL, QFXB, BMVV, VGHF, VXPK, SXDX, CPSM, KXTK, PHCX,	0 ZDTN, WPLS, MZGC, HKDT, ZFTN, RCJD, DCFV, GXRX,
43	2	QVJT, LWCK, TRWL, LPZQ,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL, QFXB, BMVV, VGHF, VXPK, SXDX, CPSM, KXTK, PHCX,	0 ZDTN, WPLS, MZGC, HKDT, ZFTN, RCJD, DCFV, GXRX, QVJT, LWCK, TRWL, LPZQ,
44	1	PTRX, CPKD, LXJC, KTNV,	KVZV, XNHM, QJFW, GFVN, PBMG, BXQD, LLRZ, CGJNL, QFXB, BMVV, VGHF, VXPK, SXDX, CPSM, KXTK, PHCX, PTRX, CPKD, LXJC, KTNV,	0 ZDTN, WPLS, MZGC, HKDT, ZFTN, RCJD, DCFV, GXRX, QVJT, LWCK, TRWL, LPZQ,

I37=IF(G37=1,I36&" "&H37,I36)
J37=IF(G37=2,J36&" "&H37,J36)

both copied down. You would then reference the last entry in each column for your answer