Forum Discussion
Compare 2 lists of data and identify a cell that meets certain criteria
=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.
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.
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.