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

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)


"cbra" wrote in message
...
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

why 'type the asset tag" ?

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

HELPVlookup

"cbra" wrote:

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

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

"Vacation's Over" wrote:

why 'type the asset tag" ?

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

HELPVlookup

"cbra" wrote:

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

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" wrote:

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)


"cbra" wrote in message
...
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

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)


"cbra" wrote in message
...
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" wrote:

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)


"cbra" wrote in message
...
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