How to check multiple columns for value in R

[nirgrahamuk]

does this new question relate to your previous question ?
It seems structurally quite similar.

Check if value from one dataframe exists in another

I am a beginner in R and want to know how it will works for each row. Eg. I have a two data frames. I want to see if the rows exist in the other multiple columns of other data frame. I want to loop every row in ab$Fruits and check if each name is somewhere in another dataframe bc[E1:E3]columns. ab<-data.frame(Fruits = c("Apple","Banana"),Units = c("3","2")) bc<-data.frame("E1"=c("Apple","Grapes","Watermelon","Na"), "E2"=c("Grapes","Berries","Custard","Guava"), "E3"=c("Apple","Banana","Grapes","Na")) eg. I want to do with loops or any function.When the loops starts, first row of ab$fruits match with each rows of bc,if first row (Apple) mat…