How to search specific values in whole excel sheet



I have to take one ‘cell’ value from one excel sheet(row by row) and i have to search that value in another excel sheet,if found i have to paste the remaining columns data for that row in destination excel sheet.

How to copy formula to the whole column

Can someone please help on this question.

thanks in advance


Hey there @Ananthaeswar2!

In excel, you need to know column names, so you can do this

if(out_dtAccountData.Select(“UniqueID=”+in_strUniqueID).Count > 0, False, True)

out_dtAccountData is from reading the excel
UniqueID is the column name
in_strUniqiueId is the value you are searching

Hope this helps.