Search Text of Cell in a range and return the contents

Hi Knowing,

Welcome to the forum.

Where you want the results ? would it be fine if I return the content in column C basis the entries in column A ?

Regards,
DILIPandey

<click on below 'star' if this helps>