Hi All:

Lookup tables are far easier to use. In fact, you will find that in order to solve your problem you will need nested ifs. Nesting ifs gets ugly quick. Therefore, I recommend using the vlookup table.

I hope that helps,

Jim