Using VLookup

Using VLOOKUP, the Rep Name column will be added to each sales invoice using the Rep ID field as the map between the two sheets. In order for VLOOKUP to work, these simple rules must be followed: a) The left column of the lookup table needs to contain the key field. ................
................