I have 2 tables and (for the sake of example) both have a customerID and PurchaseDescription column.
I want to add an additional 'does it match' type column in the 2nd table to see if the PurchaseDescriptions match in both tables, for each customerID.
The customerIDs arent in any order and there may be CustomerIDs that arent in both tables.
How can I do this? vlookups? help would be greatly appreciated...
@void started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I have 2 tables and (for the sake of example) both have a customerID and PurchaseDescription column.
I want to add an additional 'does it match' type column in the 2nd table to see if the PurchaseDescriptions match in both tables, for each customerID.
The customerIDs arent in any order and there may be CustomerIDs that arent in both tables.
How can I do this? vlookups? help would be greatly appreciated...