when i scan our barcodes on our products it displays the product numbers in
excel, how do i then set up a formal in excel to equal the product name when
the product numbers are entered?

Hi,

with vlookup, as

=VLOOKUP(A1,E:F,2,FALSE)

where A1 was your scan, and E1 onwards was a list of product codes, and
F1 onwards a list of matching names.

These are usually on another sheet, so:

=VLOOKUP(A1,Sheet1!E:F,2,FALSE)

works better.


mantha09 Wrote:
when i scan our barcodes on our products it displays the product numbers
in
excel, how do i then set up a formal in excel to equal the product name
when
the product numbers are entered?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=489763

Hi

thanks for your help but i still cant get it right!!

this is a sample of what i have-
barcode code Product Name
55663320 000 Can of coke
55663322 001 Can of sprite

what i want execel to do is when i scan the barcode number in the sperdsheet
the product name will rekonise the number and automactily enter the product
name.

is this possibly?



"Bryan Hessey" wrote:


Hi,

with vlookup, as

=VLOOKUP(A1,E:F,2,FALSE)

where A1 was your scan, and E1 onwards was a list of product codes, and
F1 onwards a list of matching names.

These are usually on another sheet, so:

=VLOOKUP(A1,Sheet1!E:F,2,FALSE)

works better.


mantha09 Wrote:
when i scan our barcodes on our products it displays the product numbers
in
excel, how do i then set up a formal in excel to equal the product name
when
the product numbers are entered?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=489763