how to check two range of data and compare them based on a cell in other column

Hi;

In attached I have 3 columns, and i want to check and compdare data in A and compare with all related in C ,based on B clumn which contains "A".
For example all cells in A which contains "abcd0002" and have "A" in B column, should have "Hold" in C column.
File is attached.

Thanks in advence.cheking.xlsx

let me explain it in another way:

if in a row A2 is "abcd0002", B2 is "A", C2 is "Hold" then, this value "Hold" should be considered as reference to check other rows which A columns contains "abcd0002", B columns is any data, C should be "Hold" otherwise the value is wrong.

See more clear example:6-24-2013 11-12-52 PM.jpg

Originally Posted by alansidman

I don't believe that you have given us all the logic. You have Hold in column C when abcd0002 is not in column A. Let's have all the criteria for your issue.