Find Missing Values By Comparing Two Columns / Find Missing Data In Column

[Howardc]

I have a workbook containing several sheets. I would like to compare the account numbers on Sheet1 Col C with sheet imported data Col A

I would like a formula in sheet 1 Col F to compare the account numbers on sheet1 Col C to sheet "imported data" Col A and where there is an account number on sheet "imported data" Col A and this does not appear on sheet1 Col C, then to indicate the account number in Col F and the value in Col G

I would also like to compare imported data Col A with Sheet1 Col C and to do a similar formula in Sheet imported data Col D and indicate the value in Col E

[Excel Fox]

Sheet1!F2=IFERROR(INDEX('Imported Data'!$A$2:$A$34,SMALL(IF(ISERROR(MATCH('Imported Data'!$A$2:$A$34,Sheet1!$C$2:$C$17,0)),ROW('Import ed Data'!$A$2:$A$34)-1,""),ROW('Imported Data'!$A2)-1)),"") as array formula

You are replicate the rest for your other cells.

[Howardc]

Thanks for the help, much appreciated

There are two account numbers in the sample file appearing on sheet imported data and not on sheet1. However, the formula only indicates account 1130 as not appearing on sheet1, whereas account 1130 and 1131 do not appear on sheet1 (they appear on sheet imported data)

It would be appreciated if you could check the formula in the attached workbook and amend your formula accordingly

[Excel Fox]

Just enter in the first cell as array. And drag down. Do not enter the formulae in one go for all the cells.

[Howardc]

Thanks for the help