Using IF, AND, OR and VLOOKUP in one

bat18

Board Regular
Joined
Mar 29, 2010
Messages
89
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
 
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.
 
Upvote 0
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.
 
Upvote 0
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), "")
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top