Forum Discussion
Solved
Compare 2 lists of data and identify a cell that meets certain criteria
Below I have 2 lists and you will see a few lines are on both list but there are a few that are on 1 but not the other. If I am looking on my SCH List and see an invoice on this list that is over...
=IF(AND(D40>1000,ISNA(MATCH(C40,Sessions!$A$3:$A$1219,0))),"above 1000 and not in Sessions","")You can try this formula. It's shorter than the original formula and it's adapted to the layout of your data.
It didnt allow me to upload the file i created
=IF(AND(D40>1000,ISNA(MATCH(C40,Sessions!$A$3:$A$1219,0))),"above 1000 and not in Sessions","")You can try this formula. It's shorter than the original formula and it's adapted to the layout of your data.