BusraGulen
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?
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?