Index and Match Only If Adjacent Cell Value is True

Hi Guys,

I would be very grateful if someone could help me.

I have a spread sheet with the following columns:

A: Equipment Number
B: PM Number
C: PM Ref

There are duplicates of some Equipment Number values in column A, as some Equipment Numbers have more than one PM Number and either a PM Ref of 1 or 2.

In a separate table, I am trying to insert a formula into column F that returns the ‘PM Number’ for each ‘Equipment Number’ value with a ‘PM Ref’ of 1.

I have tried various INDEX and MATCH combinations, but I am struggling to match the Equipment Number and PM Number with the ‘PM Ref No’ of 1.

I have attached an example.

Any help would be greatly appreciated.

Many thanks,

Duggerz