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
Bookmarks