Vlookup with multiple conditions?

[majon96]

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

 

[Aladin Akyurek]

Do a search on multi-keylookup on this board.