Hello everyone,
I am working on a dashboard to automatically calculate line efficiency based on product type and production line.
I have a total of 12 production lines and over 100 different product types. Each line has a set amount of product coming out (yield) depending on the product type. Example: line 1 yields 1000 units per hour of product X.
I have set up all the product types in a single column and all the production lines in multiple adjacent columns so that the product type and the production line intersect one another, and reflects the yield value on that intersection (a given cell).
My question is: how can I set a random cell (A1 for example) to display the yield value from an intersection? Provided that two other cell (A2 & A3 for example) are showing the production line and the product type (example: A2 = Line 1 & A3 = Product X... A1 then MUST equal 1000).
I thought VLOOKUP would do the trick, but I'm seriously stuck!
Please help me somebody! hahahahahahahahahahaha
View:
I am working on a dashboard to automatically calculate line efficiency based on product type and production line.
I have a total of 12 production lines and over 100 different product types. Each line has a set amount of product coming out (yield) depending on the product type. Example: line 1 yields 1000 units per hour of product X.
I have set up all the product types in a single column and all the production lines in multiple adjacent columns so that the product type and the production line intersect one another, and reflects the yield value on that intersection (a given cell).
My question is: how can I set a random cell (A1 for example) to display the yield value from an intersection? Provided that two other cell (A2 & A3 for example) are showing the production line and the product type (example: A2 = Line 1 & A3 = Product X... A1 then MUST equal 1000).
I thought VLOOKUP would do the trick, but I'm seriously stuck!
Please help me somebody! hahahahahahahahahahaha
View: