I’m trying to formulate an IF function but I am having trouble the conditions are as follows: IF five cells e.g. C1:C5 contain the numbers 1,2 & 3 then condition “C” IF five cells do not contain one of the 3 numbers then condition “B”. I would also like to know if this can be done with 7 cells e.g. D1:D7 the conditions are IF cells contain letters L, M & H then condition “C” IF cells do not contain one of the three letters then condition “B” The source from the five and seven cells are VLOOKUPS, I hope this is clear can anybody help me?

Thanks in advance.