I have a situation where I need to a number rating 8-1, depending on if you are married, divorced or single and your age less than 21, more than 21, and more than 35. How do you state that in a cell using a vlookup, lookup or reference?

---

Reply from Richard Rost:

I'd need to know more about how your sheet is set up, how the criteria are assigned, etc.