If statement with Vlookup

[Marty]

I need help.
I have a cell that can contain either 10% or 20% on sheet A.
In this same sheet I have a cell where I want to ask it to do the following:
If cell value is 10% then lookup value x on sheet B and return column 13
value of sheet B, but if value is 20% in sheet A I want it to lookup value x
on sheet B an return colum 12 value. My formula works for 10% but it doesnt
wokr for 20%. This is the formula I have: =IF($D$5=10%,VLOOKUP(C14,'Precios
Regulares'!$A$3:$M$28,13,IF($D$5=20%,VLOOKUP(C14,'Precios
Regulares'!$A$3:$M$28,12,FALSE)))) Please help.

Hi

You're missing a bracket from the middle and you've got an extra one at the
end! Try this:
=IF($D$5=10%,VLOOKUP(C14,'Precios
Regulares'!$A$3:$M$28,13),IF($D$5=20%,VLOOKUP(C14,'Precios
Regulares'!$A$3:$M$28,12,FALSE)))

Andy.

"Marty" <[email protected]> wrote in message
news:[email protected]...
>I need help.
> I have a cell that can contain either 10% or 20% on sheet A.
> In this same sheet I have a cell where I want to ask it to do the
> following:
> If cell value is 10% then lookup value x on sheet B and return column 13
> value of sheet B, but if value is 20% in sheet A I want it to lookup value
> x
> on sheet B an return colum 12 value. My formula works for 10% but it
> doesnt
> wokr for 20%. This is the formula I have:
> =IF($D$5=10%,VLOOKUP(C14,'Precios
> Regulares'!$A$3:$M$28,13,IF($D$5=20%,VLOOKUP(C14,'Precios
> Regulares'!$A$3:$M$28,12,FALSE)))) Please help.