In this particular example, OR wouldn’t work and I would suggest what armughal has already suggested: Use vlookup. I had one situation at work where I needed to put more than 7 IFs in a statement and my co-worker solved the problem using OR. I like VLOOKUP more.