Tender data and asset Audit comparison Vlookup help

Thanks.

I tried this same thing yesterday and it didn't work- all good now.

I havent put anything into the Variances/report tab, but basically any duplicates need to be in that tab- in seperate rows (so I can tell which data set they came from [i've made each data set a different coloured font]), and have their information in the same columns.

so if there is for example- one barcode found in all three, then there would be three rows- each with the same barcode (in their different font colours), with the rest of the information for that row showing as well.