I have to update a workbook for a customer regarding PCs that my company
ships out. Two of the fields that we record are ASSET TAG and SERIAL NUMBER.
These 2 pieces of data are already linked prior to shipment. For example
SN 1234 is linked to asset ABCD. I'd like to do a validation on this data as
I enter it to ensure there are no typos, or multiple assets assigned to 1 SN.
Which Excel Formula should i use for this? ANy thoughts