Ok, so anyone in department 200 gets a salary of $10K plus a commission of 2%, right? But if I follow this, that commission is 2% of some other number, not of $10K but of that worker's gross sales or something. Oh, wait, I see it; the sales figure is in C2 through C5.

So in D2 through D5 you need to calculate each employee's take—which is his salary (from C10 through C13) plus his percentage commission (in D10 through D13) times his sales (in C2 through C5). Your formula, let's see....is right except it uses D2 instead of B2 in the second VLOOKUP.

Now, your first reply shows you're reluctant to stop and think about this, so if you don't understand the above, I'll stop here and wait for you to put forth some effort. (Sound just like your teachers, don't I? Sorry, that's how it is.) I won't stop answering your questions; but you gotta ask good ones, which means you have to think hard about what you're trying to do and what it is that's holding you up.

Oh, and just so you don't get discouraged, that doesn't mean you can't stop, back up and start from the beginning. It sounds like you understand what salary, sales and commission are and how they work together, for example; but if not, ask.