If the Vlookup

[JessicaR]

Hello

I am trying to combine an IF formula with a V-lookup. The formula is dependant on the data selected in two separate data validation list.

1st Data validation list is to select which rate card is to be used (B6)
2nd Data validation list is a selection of roles , i.e. Project Management (C12)

I am trying to achieve the following

If you select a rate card in the data validation list 1, then the Vlookup should look at the role showing in validation list 2 and enter the rate in that field as per the table array and column index number selected for this rate card

I have pasted my formula below and it returns the value "False" in the cell and I do not understand why it is not working. Have I missed something in the IF section?
I have approx 7 different rate cards to pop in this formula (not sure if VBA may be a better option)

=IF($B$6="standard",VLOOKUP(C12,'RATE CARD'!B7:Q17,4,FALSE),(IF($B$6="CustomerB",VLOOKUP(C12,'RATE CARD'!B7:Q17,16,FALSE))))

Any help would be greatly appreciated

S

 

[VoG]

Try

=IF($B$6="standard",VLOOKUP(C12,'RATE CARD'!B7:Q17,4,FALSE),IF($B$6="CustomerB",VLOOKUP(C12,'RATE CARD'!B7:Q17,16,FALSE)))

 

[JessicaR]

Thank-you very much, it works now I just could not spot the error

J