• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find the first value and display the adjacent cells values.

Hi

The below snapshot Column A to L is the base data. The right side P column is the Input and the Q column values are the expected results.

Example
Column C RM1 used in rows 8, 11, and 15 the product is 3, 6 10
Column J RM8 used in row 11 and 15 the product is 6 and 10
Likewise, I have manually filled the first finding products in the expected results.
I need formulas to find the same and fill the all used product names to be displayed as below.

RM1 ==> Product 3, Product 6, Product 10
RM5 ==> Product 6, Product 10

75709
 

Attachments

  • Find the used product names.xlsx
    11.3 KB · Views: 9
Working well Thanks @bosco_yip

This formula extracting the first used product Name only, Is there any way to get all used products like below?
RM1 ==> Product 3, Product 6, Product 10
RM5 ==> Product 6, Product 10
 
Working well Thanks @bosco_yip

This formula extracting the first used product Name only, Is there any way to get all used products like below?
RM1 ==> Product 3, Product 6, Product 10
RM5 ==> Product 6, Product 10
Maybe :

=TEXTJOIN(", ",,IF(INDEX(C$6:L$39,0,MATCH(P6,C$5:L$5,0))>0,B$6:B$39,""))

Ctrl+Shift+Enter array entry and copied down

Regards
 
Last edited:
Back
Top