If, Vlookup & And Join Together

[muhammad susanto]

hi all...
how to use if, vlookup & and together like this :

=IF(VLOOKUP($AL$8;KKI!$A$2:$P$137;11;0)=U71;"V";"")

i want to adding AND function, e.g. in cell AF79 with criteria in cell "AF79>0"

how to add that function?
maybe modify : =IF(And(VLOOKUP($AL$8;KKI!$A$2:$P$137;11;0)=U71;"V";"";>0"

but not work for me...

would you help me?

susanto

thanks

 

[JazzSP8]

You need to separate the AND conditions you want to register as true when using AND, eg;

=IF([COLOR=#ff0000]AND[/COLOR](VLOOKUP($AL$8;KKI!$A$2:$P$137;11;0)=U71[COLOR=#ff0000];AF79>0[/COLOR]);"V";"")

 

[muhammad susanto]

hi jazzsp8...thanks but still not work..

 

[JazzSP8]

Then I'm not sure what the problem could be, but that is the correct syntax for using AND

How is it not working?

 

[muhammad susanto]

if in cell AF79>0, in cell U71 should be not check listed. (mark "V")

 

[JazzSP8]

Sorry - you've lost me, check listed?

Is that what the VLOOKUP is doing?

Can you post a sample of your data and the conditions that should result in the "V" please?

 

[muhammad susanto]

here this link

https://app.box.com/s/1uxuldyewvvj40acj185a4rv4ypbd8iw

 

[muhammad susanto]

i hope someone could help me