I have 2 workbooks in one spreadsheet - W1 and W2. both have A FIELD iWOSH TO COMPARE. I want to compare that field and if there is an exact match then write a third workbook ONLY with all the data from W1 into the 3rd workbook..make sense..The formula is driving me crazy