vlookup problem

[John27]

I have two columns on one sheet - namely bonus plan name which has a listing of 6 possible bonus Plans (A,B,C,D,E,F)

The next column to the right has a listing of 5 possible performance rating for an employee (AA, AB, AC, AD, AE)

In a separate column - using vlookup - I'm trying to input a bonus payout % number

There are completely different bonus payout % numbers for an employee - (based on what bonus plan and what performance rating they have.

Can anybody help with a vlookup formula that will work using two conditions! Maybe this requires something different.

Thanks.

[nisht]

If you want to work with two conditions .. you can dowload my file nos. 11 from my download site http://www.pexcel.com/download.htm

here you can use the function which will help to get the result of two conditions.

nishith desai
http://www.pexcel.com