Possible to simplify this formula further?

Hi, I am trying to compare two workbooks and identify the cells which have been changed. I managed to get the formula working however I'm hoping to simplify it further and possibly removing the need to copy and paste a "concatenate" formula on the workbook2.

Here's what I'm doing :

1) Open workbook2 and on the last column (column I), I'll paste CONCATENATE(A7,E7,H7) formula. I do the same for all the tabs

2) Open workbook1 and on the last column, I'll paste IF(ISERROR(VLOOKUP(CONCATENATE(A7,E7,H7),'[Document.xls]Sheet1'!$I:$I,1,FALSE)),"Updated","Not Updated").

3) Repeat Step 2 for all the tabs in workbook1

What it does then is to compare both values from Workbook1 and Workbook2 and if there is a match it will return the value "Not Updated", if there is a variance it will return "Updated" instead.

I'm trying to figure out a way to remove step 1 which is to manually paste the formula as I have multiple tabs. Does anyone have any solutions to do this?

Appreciate your input.

Thanks in advance

=if(countifs('[Document.xls]Sheet1'!$a:$a,a7,'[Document.xls]Sheet1'!$e:$e,e7,'[Document.xls]Sheet1'!$h:$h,h7)>0,"Updated","Not Updated")

Thanks for your responses. Would it be possible to incorporate the concatenate formula (workbook 2) into the vlookup formula (workbook 1) by any chance?

hmm ... i'm trying to replace the table array with a concatenate. Tried the following but it doesn't work. Do you happen to know any alternatives to this?

=IF(ISERROR(VLOOKUP(A7&,E7&H7,'[Document.xls]Sheet1'CONCATENATE(A7,E7,H7),1,FALSE)),"Updated","Not Updated")

Pl try this in Workbook1. There is no necessity to concatenate in Document (Workbook2).

Please Login or Register  to view this content.