Hi,
How can I use more that Creiteria to check ????
e.g

A1 want to know what is the value in in clomun D if matches with Mat1
first,or second M_A_2 Exist, or third A_B_A exist all in column C???


C D
1 MAT_1 5
2 M_A_2 6
3 2_A_2 9