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.
Can you upload a file which shows where the data is entered in your sheets? For example in the attached .pdf file you can see where the data is entered.
The most convenient way would be if you can enter sample data in the .xlsx Excel file however.
Sure! Attached you will see an example excel work book. 2 tabs, 1 for ACH SCH and 1 for Session. Some items are on both, tabs, some are not, I need to identify the items on the ACH SCH list that are over 1,000 and not on the session tab.
- 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.