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" wrote in message
...
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.