data validation using vlookup
 

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

data validation using vlookup
 

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

data validation using vlookup
 

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

data validation using vlookup
 

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

data validation using vlookup
 

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

data validation using vlookup
 

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