Help using a formula to compare two colums of text.

Hello Forum,

I am trying to compare two columns with location data drawn from two different sources, thusly returned with two different methods of reporting.

Specifically (this data is made up as an example):

Client has two sites. Cardiff as the head office and London as the field office.

Client database lists these two as Cardiff and London.

Discovery tool lists these as HQ and Field respectively.

I am trying to find a function that would allow me to compare the two and match Cardiff to HQ, and London to Field. Reporting it in the manner displayed in the example below:


Sample Data 2.jpg