VLOOKUP over 2 criteria

Hi there,

I've got a massive data set to analyse and I need to make the set usable first. Unfortunately the records that refer to a unique identifier (MRP#) are split over several rows. Please see example.

What I need to do is to transpose some of the data over from rows to the columns.

Say the MRP# appears in 4 separate rows with a set operation (in this case CUT, WELD, FAB, PAIN). If i have a record with operation CUT, I want to find the corresponding MRP# for FAB and copy the data across. So I believe in this case the criteria will be both the MRP# and phrase "FAB STEEL".

I know that VLOOKUP won't work in this case. I've also tried INDEX and MATCH but it didn't work so I must be doing something wrong. Please help!

Thanks in advance!

K