data validation using vlookup

[Guest]

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

 

[Bob Phillips]

Why do you need DV, surely each serial num has just one asset tag, so just
have the serial number entered and then VLOOKUP for the asset tag.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

why 'type the asset tag" ?

just place a Vlookup formula in the asset tag column and let it look it up
for you

HELP>Vlookup

 

[Guest]

This is really supposed to be a QA check on what number was assigned. (not my
decision, but I have to live with it).

 

[Guest]

I am actually recording what asset tag sticker was placed on the machine. The
list of SN and Asset tag # I have are the correct cooresponding numbers; so I
am really checking that the asset tag sticker we used is the correct one.

 

[Bob Phillips]

Best to just list the assts in the DV and do the VLOOKUP in an adjacent
cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)