< > vlookup

[liamsdad]

I have 3 columns of data. Column 1 is a percentage to goal, Column 2 is a low pay range and Column 3 is a high pay range.
If I have sales that equal 1 criteria I am paid out of the high pay range base on the percentage to goal if I do not meet that criteria I am paid off the lower.
Here is an example that I came up with but can not get it to work.

(IF(O80<O81,VLOOKUP(N8,Bonus3,2,)))OR(IF(O80<O81,VLOOKUP(N8,Bonus3,3)))

[Maistrye]

I have 3 columns of data. Column 1 is a percentage to goal, Column 2 is a low pay range and Column 3 is a high pay range.
If I have sales that equal 1 criteria I am paid out of the high pay range base on the percentage to goal if I do not meet that criteria I am paid off the lower.
Here is an example that I came up with but can not get it to work.

(IF(O80<O81,VLOOKUP(N8,Bonus3,2,)))OR(IF(O80<O81,VLOOKUP(N8,Bonus3,3)))

I'm not sure I follow what you're trying to say. Do you have some sample data you can post? ie. Give the first 3 or 4 rows of the table with the 3 columns, and give two examples of different input values and what you'd expect to be returned. (Make sure one of the examples returns the low pay range and one returns the higher pay range.)

(Primarily, I don't understand how you are distinguishing between pay ranges)

I'd guess without seeing anything that you can go like this:

=IF(O80<081,VLOOKUP(N8,Bonus3,2,false), VLOOKUP(N8,Bonus3,3,false))

Scott

[liamsdad]

This is the sample data, Thanks for the assistance.

[Maistrye]

Do I understand this correctly?

If your goal is $50,000, and your sales are at $45,000, you are at 90%.

Second, if O80 < O81, you get the BonusK7. If O80 >= O81, you get BonusDM1.

Anyway, if this works, that's sort of irrelevant. The function I would suggest is:

=IF(O80<O81,INDEX(Bonus3,MATCH(N8,Bonus4,1),2), INDEX(Bonus3,MATCH(N8,Bonus4,1),3))

Where Bonus4 is ='NOV 06'!$R$1:$R$91

Also, I'd recommend that you change the ranges for all your Bonus names to start on Row 3 instead of Row 1.