How to automatically generate the Assembly product name of column H according to Part Code

UDF
https://www.excelforum.com/excel-pro...ml#post5231003

Use in cell like
Seet2!H5:
=JoinIf(Sheet1!$A$5:$B$25,2,A5,1,",")
where;
Sheet1!$A$5:$B$25 = Data range
2 = relative column index within data range for key.
A5 = the key to be searched
1 = relative column index within data range for items to be joined.
and copy down

Please Login or Register  to view this content.

If you want to call it from the procedure then add

Please Login or Register  to view this content.

Good evening, teacher, Teacher you help me the answer again, you are a great teacher, thank you very much
こんばんは、先生、あなたはまた先生です、あなたは私が答えるのを助けます、あなたは素晴らしい先生です、どうもありがとう