Good morning Excel Community,
I have been stumped on this for several days/weeks now and joined this forum to hopefully gain some insight. The attached Workbook is clean and shows the details of my problems. I am trying to create a single list based on multiple criteria evaluated amongst multiple datasets. I am able to return the values needed using index/match formulas and turn it into a list using MIN(IF(ISNA(MATCH(ROW functions, but only when I'm using a single dataset (Review Section). I have been unsuccessful in converting the formulas to evaluate all the review sections and create a list as a result. My actual Workbook contains perhaps 100 datasets and I am trying to create fillable formulas that will create the list shown in the "Discrepancies" Tab while analyzing every single data set from the "NPM Cigarette Invoice Review" Tab.
Your help is greatly appreciated.
Nick
Bookmarks