Nested IF In Excel

[ksikor14]

I Have a spreadsheet that contains Data and I have a second tab and on the second tab I want if Column T4:T58 equals Yes and if Column U4:U58 equals Test1, then populate column into the cell and I can't seem to get the logic correct. Column B4:B58, has Customer Name, Column Q4:Q58 has Date, Column S4:S58 has Item Description.
I tried this but it brings in Column B even if both conditions are not Yes and Test1. Not sure what I am doing wrong. =IF(OR('Order Tracker'!T28="Yes",'Order Tracker'!U28="Test1"),'Order Tracker'!B28,0) Please help anyone!

Example
Test 1
Customer Name Date Item Description

[TABLE="width: 500"]
<tbody>[TR]
[TD]Tech World
[/TD]
[TD]5/1/2019
[/TD]
[TD]Hex Bolts
[/TD]
[/TR]
[TR]
[TD]Bravo Inc
[/TD]
[TD]4/8/2019
[/TD]
[TD]1/2" Screws
[/TD]
[/TR]
[TR]
[TD]Stanley Services
[/TD]
[TD]3/15/2019
[/TD]
[TD]Lock Washers 1/2"
[/TD]
[/TR]
[TR]
[TD]Atoka County
[/TD]
[TD]2/1/2019
[/TD]
[TD]1/4" Nails
[/TD]
[/TR]
[TR]
[TD]Translucent
[/TD]
[TD]5/3/2019
[/TD]
[TD]1/2" Nails
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jimrward]

Have you tried AND instead of OR

 

[ksikor14]

No I will try and see what it does thank you

 

[jimrward]

AND means both conditions have to be true OR means any of your conditions

 

[ksikor14]

I tried And, and it gives me False even though I know both conditions are equal on 5 items.

 

[jimrward]

I would be double checking some of the cell contents to make sure there are no trailing or leading spaces
Add in an extra column with a simple if(T28=“yes”,1,0) and another for U28 and see if any slip thru