Hi Excel Geeks

This is another one of my index match scenarios - that is triangulating me.

I am trying to match the first name and surname on one list to a second list of names and if they match to select the new department they work from the worksheet labelled ‘list of names with costs and new department (de)’ and then pick the cost against the matched name from the first list – ‘Names to match costs and new depts’ and insert the costs under the correct new department. I have attached a sample file to clarify what I am trying to achieve.

 Any suggestions of doing this in an efficient way would be greatly appreciated.

Regards

Mel