Hello,

I have a formula that pulls from sheet1 and adds a / in between the 2 words on sheet2.

=REPLACE(ACTExport!C2,4,0,"/")&ACTExport!B2

I want to use the IF function to only show ACTExport!B2 if ACTExport!C2=ACTExport!B2 but if not then show both.

Example. YYY/XXX but if XXX/XXX then only show XXX no backslash.

I am fairly new to using functions and formulas so any help is appreciated.