vlookup problem

[dgavin]

=IF(AND(Dutch!$F$45="BET",S5<>"",S5>0,$U$1>Controls!B4,L2=0,VLOOKUP(F5,Dutch!C18:E42,3,FALSE)),Controls!$B$6,"")


I have added a vlookup into the formula above but its not formula is returning an error

basically if the vlookup ="A" for the formula to be true

 

[Jonmo1]

AND needs True or False values.
Vlookup returns a value (either string/number/error)..

Try

=IF(AND(Dutch!$F$45="BET",S5<>"",S5>0,$U$1>Controls!B4,L2=0,VLOOKUP(F5,Dutch!C18:E42,3,FALSE)="A"),Controls!$B$6,"")


hope that helps.

 

[T. Valko]

=IF(AND(Dutch!$F$45="BET",S5<>"",S5>0,$U$1>Controls!B4,L2=0,VLOOKUP(F5,Dutch!C18:E42,3,FALSE)),Controls!$B$6,"")


I have added a vlookup into the formula above but its not formula is returning an error

basically if the vlookup ="A" for the formula to be true

You haven't included the comparison value for the VLOOKUP.

Maybe this:

=IF(AND(Dutch!$F$45="BET",S5<>"",S5>0,$U$1>Controls!B4,L2=0,VLOOKUP(F5,Dutch!C18:E42,3,0)="A"),Controls!$B$6,"")