Using IF, AND, OR and VLOOKUP in one

[bat18]

Hi,

Here is my problem I am trying to write

'if the value in E1 is anywhere in column T AND either R1 OR S1 is in column U then TRUE, otherwise FALSE'

Now using vlookups to get the values works fine, also when i combine the IF statement with AND it works but when i try

=IF(AND(VLOOKUP(....., OR(VLOOKUP....

it just wont work. Any help on this would be greatly appreciated

Thanks

 

[bat18]

I have a column with the following formula in

=IF(AND(M12="s", M12<>""), SUMIF(C:C, C12,N:N ), "")

I then use another formula to match the value obtained from this formula with values entered into another column.

 

[dcamos]

The only thing I can think of is that since it is adding numbers together you might not have the exact result, it could be off by tenths or less of a point and cause it not to find the number.

 

[bat18]

So you believe this match formula should pick up any value that is in V3 and column Q even if the value in V3 is the result of the above formula??

=IF(V3<>"", MATCH(V3,Q:Q,0), "")