Search for Value and Insert Value in different column if a hit is found

**tejmankala** · 08-07-2011, 01:47 PM

Hi there,

I have a requirement wherein I will be doing a manual Find for employee names in Column A and then insert a Yes in Column B if I find the employee name in the sheet. There can be many occurences of the employee name i.e. multiple rows , so I need "Yes" in column B in all these rows where I find my desired employee name.

So, bottomline is, the second part should be automated, i.e. once the hit/s is/are found, it should insert values "Yes" in column B in all the "found" rows.

Please can anyone help me in doing this? Can i do this using Macro or should I use VBA? I am not so familiar with either of it, however. Thanks

Regards

**Haseeb Avarakkan** · 08-07-2011, 02:08 PM

Hello,

Cosider, Sheet1 Col_A has the all employee names.
Sheet2 Col_A is the some name for checking already existing in Sheet1 Col_A.
So try any of these in Sheet2 B1, & copy down

=IF(COUNTIF(Sheet1!A:A,A1),"Yes","")

Or,

=IF(ISNUMBER(MATCH(A1,Sheet1!A:A,0)),"Yes","")