Hi,
I need a formula that will look down column D and match 'TLC' and column C for 'NG' - returning the first EIN match from column A.
I will need to drag down the formula and return the next EIN match from the above criteria, but avoiding any duplicates that have already been returned above...