Need help regarding search string function

[Anirban Majumdar]

I am using below function to search a string for a matching word from another string and the logical test is performed and if true (e.g., XXX), the value_if_true output is given (e.g., YYY), else the output in the value_if_false parameter is given.

IF(ISNUMBER(FIND(""XXX"",RC[-1],1))=TRUE,""YYY"", <should fetch value from another column value>)

Now i want to give the value fetch from another column value. Need help how to put value in above RED string referencing another column value directly.

 

[Anirban Majumdar]

The full function is:
IF(ISNUMBER(FIND(""XXX"",RC[-1],1))=TRUE,""YYY"", <fetch from another column value><should fetch="" value="" from="" another="" column=""></should>)

Can anyone please help ??