Check Text in cell

[fairymemay (noona)]

Hello.

I want check Text in cell from file input.xlsx with file master.xlsx by use formular in excel.

Condition

1. Check column text in file input with column text in file master
   1.1 If match check data in column SR Detail in file input with column SR Detail Wording

• data in column SR Detail in file input have text contains (ignore case,ignore space) with column SR Detail Wording sheet master —> write column D in column input = Y

Example output = column D in red text.

Please guide me for solve it.

Thankyou.

Input.xlsx (10.9 KB)
Master.xlsx (12.6 KB)

[vrdabberu (Varunraj Dabberu)]

Hi @fairymemay

Check out the below zip file. Hope this meets your requirement:
BlankProcess33.zip (60.3 KB)

Input.xlsx has the required output after running the process.

Regards

[fairymemay (noona)]

@vrdabberu
Can you code with formular excel?

[vrdabberu (Varunraj Dabberu)]

Hi @fairymemay

Give me some time. I will get back to you.

Regards

[fairymemay (noona)]

@vrdabberu I will waiting from you.
Thank you

[vrdabberu (Varunraj Dabberu)]

Hi @fairymemay

Check out the below zip file. Hope this meets your requirement.

BlankProcess33.zip (99.3 KB)

Regards