Multi Variable Vlookup? (or a comparable function)

[waronpugs]

I have a cell that I need to populate with data based on the information of two different cells. To lay this out for you all: I have a sheet that is going to generate payment based on a sales person's status (Certified or Trainee), and the classification of their sale (1st, 2nd, or 3rd-level sale). Certified Sales people will make more than trainees, and the overall pay level is highest at level 3.

Trainee:

1 - $50
2 - $100
3 - $150

Certified:

1 - $100
2 - $150
3 - $200

So, on the work sheet there is a cell for the sales person's status, and a second one for the level of sale that was closed. I need the dollar amount to generate based off of both of these cells. Would this be a variant of the VLookUp function or is there another function that will do this?

I thought I'd upload a picture in case that helps some of you. The Dollar Amount (excuse the typo) is the one I need to populate. The C1 field is just a standard vlookup function so all that ever needs to be inputed is the name and the sale level on the left.

 

[Simon4s]

Sorry to double post, I didn't see an option to edit my initial post. I thought I'd upload a picture in case that helps some of you. The Dollar Amount (excuse the typo) is the one I need to populate. The C1 field is just a standard vlookup function so all that ever needs to be inputed is the name and the sale level on the left.

Follow my steps exactly.

1. Select F8:G10
2. right click
3. select define name
4. Call it "Certified"

5. Select I8:J10
6. right click
7. select define name
8. Call it "Trainee" without quotes ofcourse

9. In C3, enter this formula "=vlookup(C2,indirect(C1),2,false)

** i assume you already have a vlookup in place for C1**

 

[waronpugs]

Thank you. This worked perfectly!