Using Vlookup with 2 criteria (or other function) 2

[Mikeb1970]

Hi all,

I have a spreadsheet that contains all production codes and times from all our machines.

What i'm trying to make is a visual view off the time used for each machine to do their steps.

I have this working quit well, using the match offset combination.

I now wanna add some features, but need to look at two criteria instead of one for finding a start time on a machine. I know this can be done using an advanced filter, but due to some practical reasons don't prefer this way.

Is there a way to make a formula using whatever function needed???

With regards and happy holidays

Mike

 

[bluedragon2]

See above for reason

Blue

If I wasn't Blue, I would just be a Dragon...