Forum Discussion
Comparing Two Worksheets, please help!
I have two worksheets in a workbook, 'Master' and 'TB43-180'. I need something that will check each line in the Master against each line in TB43-180, such that if the model, nomenclature, and...
Looking more closely at your picture, my best advice is to prepare an "index" column by concatenating 2 or more "key" fields (columns) in each table and then perform a VLOOKUP, comparing the values returned for each record (line) matching the "key"
eg.: [Model]&[Barcode] to get a unique line ID and then use this value as search value in VLOOKUP.
eg.: [Model]&[Barcode] to get a unique line ID and then use this value as search value in VLOOKUP.
- Villaseca, thank you for your help but I honestly would not have a clue how to do that. Would you be able to show me what code is needed and where based on the worksheets I provided?
