John,

A personal thanks for the help in logic - I didn't use your exact thoughts, but I did end up going to a vlookup solution with some changes in how I was trying to track commissions. In any event, I have what my final result is in the edited post...thanks again...