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

Tech World	5/1/2019	Hex Bolts
Bravo Inc	4/8/2019	1/2" Screws
Stanley Services	3/15/2019	Lock Washers 1/2"
Atoka County	2/1/2019	1/4" Nails
Translucent	5/3/2019	1/2" Nails

<tbody>
</tbody>

 

[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