• 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


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

finding reference cell in a range


New Member
Hi! Let's assume that the L1:BF1 columns include the name of the supplier. Under these columns (L5:BF281), there is price information for each raw material (raw materials' names are on B5:B281). As you imagine, each raw material is not bought from each supplier. For each row (raw materials) I have just 1, 2, or maximum of 3 columns that include the number (price).

I want to have one cell that gives me information like that (price1,supplier1;price2,supplier2) for raw materials. For it. I need to check the rows includes the price for each raw material and according to that information I need to return supplier value.
How can I do it?



Excel Ninja
As a new member, You should reread Forum Rules
Ps. There are rules everywhere, even other Forums has same kind of rules as here; Chandoo.org.