Have you tried using the AND function with a VLOOKUP function as the true result?
English
-
Interesting, I've always avoided the TRUE outcome but this may be my use. I'll try when I'm back from my lunch.
-
Good luck. It does sound like you'd be better off using a database though.