can you uses vlookup within an if statement, I can both functions to work
separately but not together.

Thanks

Alec

Yes,you can use VLOOKUP( ) within an IF statement. Tell us what you
want to do and we might be able to help further.

Pete

My VLookup is =VLOOKUP(G3,PRODUCTS!$A$3:$D$311,2,FALSE)

and i'm trying to do something like this
=IF(A1="yes",VLOOKUP(G3,PRODUCTS!$A$3:$D$311,2,FAL SE)
+20%,VLOOKUP(G3,PRODUCTS!$A$3:$D$311,2,FALSE)

basically if A1 is yes, then vlookup the value in products plus 20%, if A1
is not yes then just return the vlookup value

Thanks!

"Pete_UK" wrote in message
ups.com...
Yes,you can use VLOOKUP( ) within an IF statement. Tell us what you
want to do and we might be able to help further.

Pete

You could use:

=if(a1="yes",1.2*vlookup(...),vlookup(...))

or maybe just:

=vlookup(...)*if(a1="yes",1.2,1)



Alec Green wrote:

My VLookup is =VLOOKUP(G3,PRODUCTS!$A$3:$D$311,2,FALSE)

and i'm trying to do something like this
=IF(A1="yes",VLOOKUP(G3,PRODUCTS!$A$3:$D$311,2,FAL SE)
+20%,VLOOKUP(G3,PRODUCTS!$A$3:$D$311,2,FALSE)

basically if A1 is yes, then vlookup the value in products plus 20%, if A1
is not yes then just return the vlookup value

Thanks!

"Pete_UK" wrote in message
ups.com...
Yes,you can use VLOOKUP( ) within an IF statement. Tell us what you
want to do and we might be able to help further.

Pete


--

Dave Peterson

Yes, you can't just add 20% to the value returned by the vlookup as you
are trying to do, you have to multiply this value by 1.2 (i.e. 120%) as
Dave suggests.

Pete

can you give me an example of the whole formula please

"Pete_UK" wrote in message
oups.com...
Yes, you can't just add 20% to the value returned by the vlookup as you
are trying to do, you have to multiply this value by 1.2 (i.e. 120%) as
Dave suggests.

Pete