I originally posted this as an Excel formula request to see if there was a clever way round without vb, but I don't think it's possible. VBA seems my best bet.
I want to change the contents of a cell depending upon a comparison test, this basically what I am wanting to achieve
if a2=b3 then make j2=g3 otherwise do nothing.
I will actually have a series of these to check (see my attached file). This spreadsheet details what I want to ultimately achieve, but just the above element of it would be a tremendous help