search a value in array & if the value is present in array return yes/no in the same row

I have a list of values to be searched (column B) which I want to search in Main Array (column A) and if the value is present in MAin Array (column A) the formula should return the value in column c on the same row as it is in column A


FOr e.g. : Search GHI (from column B) in column A, it is present in third row so the formula in column c should return GHI in the third row as shown in the below given table


A B C
Main
Array Value to be searched
in the main array Searched Value to be
returned on the same row as the Main Array
ABC GHI NA
DEF JKL NA
GHI XYZ GHI
JKL OPQ JKL
LMN NA
OPQ OPQ
RST NA
UVW NA
XYZ XYZ








Please help with the formula as i have thousand lines to be searched.

Thanks,
Pankaj

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.