software

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.

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