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