Hi guys,

I'm in the middle of an asset audit at work after our client wanted a second audit due to the first one not being in the right format (long story).

Our client uses barcodes to identify each asset (easily over 150K different assets), and its location, model etc..

eg: barcode: 301225 Asset Id: Fire Door Mod: FireSafe etc....

Now I've got the original tender data which was given to the company to work from, and the 1st audit data (I've adjusted the rows/ columns to match the tender format), and we are in the middle of the 2nd audit.

Now I've seperated each sets of data into their own sheets on the one file and I need to have a 'summary' sheet which displays any duplicate barcodes found in all three audits- as well as their information (location, model etc.), which is in the same row as the barcode itself.

I'm not sure if a Vlookup would be able to do this in the manner i need. ( not just the barcode- but all the information associate with the barcode as well)

eg: if barcode #123456 was found in the tender AND the 1st audit, then I need a row for both barcodes and their associated info.


Barcode Description Location Model

#123456 Fire door Building f10 FireSafe
#123456 Fire Door Building f10 FireSafe

(where plain text is data from the tender sheet and BOLD text is from the 1st audit)

The reasons it must be this way are to ensure data integrity and completeness.