Nested IF, AND and VLOOKUP Functions

[Dejavu1965]

Hi

I fully admit to being self taught novice in all aspects of excel and have limited knowledge of its full potential.
I have just joined Mr Excel as I am working on a Calculator for my wife. It currently has me completely stumped as to how I can do what I want to get done.

I am using Excel 2013

My problem is as follows:

I have two drop down boxes that I want to be able to use their value to lookup a rates table and
produce the result in a different cell. They are 'Form Control' drop down boxes. I have these working the way I want.
I am using the 'Cell Link' value in my named list to tell my formula what it is I want to look at.

The formula I am using is as follows but it is not showing me anything.

=IF(AND($D$11=2,$D$12=2),VLOOKUP($D$12+0.1,Rates,2,""))

So basically I need to look at the value in D11 and D12, make sure they are both '2', and then add .1 to D12 so it looks up the right line of the Named Table 'Rates' and return me the dollar amount that is in Column 2 or show an empty cell in I16.

Man I have just reread this myself and got confused!!! I wonder if there is anyone out there that can help me!

As I said I am a self taught novice so hopefully I can get the help I need.

Thanks

 

[StefanVL]

I think you placed the "" a bit to early. Assuming you do not want to search exactly, try:

=IF(AND($D$11=2,$D$12=2),VLOOKUP($D$12+0.1,Rates,2,1),"")

 

[Dejavu1965]

StefanVL, you are a legend!!! Works perfectly with that change! Thankyou so much.