See attached example.

I have a 6 column XLS.

Want to find Registered Companies (from Column A) in Company Name (from Column C).

If found, want to write corresponding data from Column D or E in Column B.

If Column D and E has data in BOTH, I want to write the word BOTH in Column B

Eh?ifthen.xls