User Profile
psaavedra3
Copper Contributor
Joined May 10, 2022
User Widgets
Recent Discussions
Why is my formula not working correctly
I have used a formula to find items over $1,000 and not in a session and while it finds some items correctly its still finding items that are on the sessions and still displaying as not on a session. In col E if its Yes it shouldn't have anything in col F. If you scroll down you will see a few items that have a YES in col E and "Above $1,000...." in col F. Why is that ? What is wrong with my formula. Here is the formula is col F: =IF(D48<=1000,"",IF(AND(D48>1000,NOT(ISNA(MATCH(C48,Sessions!$C$3:$C$1000,0)))),"","Above $1,000 and not in a Session"))Re: Compare 2 lists of data and identify a cell that meets certain criteria
OliverScheurich Thank you for the quick response. I have attempted to the formula but its not working. The below line is on my SCH list and is not on my Session list so the formula should return and "Above 100 but not on Session" but unfortunately its not giving me anything. Here is the formula i am using: =IF(D40<=1000,"",IF(AND(D40>1000,NOT(ISNA(MATCH(C40,Sessions!$A$3:$A$1219,0)))),"","above 1000 and not in SESSION list")) Any additional help would be greatly appreciated.
