I am currently using the following LOOKUP formula in spreadsheet EE_Pub (columns N, O and P) to find 'last match' values in spreadsheet EE_Cat (columns J, K and L), unless the value in column K of EE_Cat spreadsheet = "No Change", in which case it ignores this row.
I need to add an additional criteria to this formula so that it ignores all rows where column K in EE_Cat spreadsheet = "No Change" or "CX'd"
I have provided the two sample spreadsheets. I have highlighted the cells and included comments on the EE_Pub spreadsheet containing the results I am looking for with the updated formula.
I hope I have provided sufficient information, and that it is clear enough...