I have sheet that looks like this:
A B C
Machine Day Capacity
921 4051 10
921 4052 20
921 4053 20
333 4051 100
333 4052 150
333 4053 10
I have another sheet where I present the data, and there I want to present capacity forsome special days and machines, for example the capacity on 4051 for machine 333. The answer should be 100.
In other words I need a Vlookup that doesn't just take one, but two columns in respect when finding the number within a cell.
Anybody have an idea?
Thanks in advance
A B C
Machine Day Capacity
921 4051 10
921 4052 20
921 4053 20
333 4051 100
333 4052 150
333 4053 10
I have another sheet where I present the data, and there I want to present capacity forsome special days and machines, for example the capacity on 4051 for machine 333. The answer should be 100.
In other words I need a Vlookup that doesn't just take one, but two columns in respect when finding the number within a cell.
Anybody have an idea?
Thanks in advance