I have a spreadsheet with a list of serail numbers and their cooresponding
asset tags. I have named this range "AssetList". I have another spreadsheet,
in the same workbook, with a list of employees. I need to enter the serial
number, then type in the asset tag.

Cell A2 = Sue Smith
Cell A3= Serial Number
Cell A4 = Asset Tag

I need to use data validation to check the asset tag I have just entered
against the first list to be sure it cooresponds. What formula do I use in my
data validation when using a vlookup? Thanks