Hello,

not be on for a looong time, but am stuck and thought that someone with far superior knowledge would be able to help!

Apologies for the ambiguous title, by the way!!!!!

Thanks to all for their previous assistance.

As an example, I have two columns in a simple spreadsheet..

From what I input into A2 & B2, I want the result to show in C2. However, this should only be if they are equal.

As an example:

If A2 & B2 equal "A", then C2 will equal 1

If A2 & B2 equal "B", then C2 will equal 2

If A2 & B2 equal "C", then C2 will equal 3

However, if A2 and B2 don't match, then C2 will stay blank.

Thanks for having a look and thanks in advance for your assistance.

Regards,

Craig