Hi, I am using the following formula to Lookup multiple Columns if data is not found in column 1, but because some details have been duplicated in the tables I need to show which column the data is coming back from. How can I do this?

=IFERROR(VLOOKUP(A2,'[Common Database.xlsx]Sheet1'!$A:$G,1,FALSE),IFERROR(VLOOKUP(B2,'[Common Database.xlsx]Sheet1'!$B:$G,1,FALSE),IFERROR(VLOOKUP(C2,'[Common Database.xlsx]Sheet1'!$C:$G,1,FALSE),"")))