Compare Col B with all rows in Col A if Match Place in Col C

Hi,

Newbie here. I want to compare two columns. I would like to see if the contents of column B appear anywhere in column A, for any amount of rows, and if it does, to place the match in col C.

So in the example below, red in B1 would be checked in A1 through A1000 or however long A is. When any row has red, place that match in that row for C.

This would be repeated until all rows in B are complete.

Example
Col A: red
Col B: red
Col C: red

Col A: red
Col B: blue
Col C: not found

Thank you very much

Hi,

Please enter the following formula in C1 and drag down-

=IF(A1=B1,A1,"Not Found")

Hi Chatrody,

Thank you very much. I just want to make sure, so you are taking B1 checking all the way down A1 - A1000 or any number, then going to B2 and repeating? Just want to make sure that it is not just checking 1 row.

If you want to search the whole column A, then use the following formula in C1 and drag down-

=IFERROR(VLOOKUP(B1,A:A,1,0),"Not Found")

Perfection Chatrody!!!! Thanks

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful.

I clicked the add reputation star, if that is the one that you mean. Thanks again.