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