View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
adamkane[_2_] adamkane[_2_] is offline
external usenet poster
 
Posts: 1
Default Need to find a match


Not sure how to explain, but here goes. I am getting some barcoding
software to track the shipmaent of some products. When I receive the
products they come with an Excel speadsheet that contains information
about the person(s) they are going to. Each product will have a Barcode
with a number imbedded in it that is already present in the Excel
Spreadsheet. I'm looking for a way for the number in the barcode to
find it's matching barcode in the Excel spreadsheet and populate in a
determined cell on the same row.

Example

798556 Mr. John Doe 3200 Phillip Lake Dr. Northport AL 35406 798556


The first number "798856" is already present. The second "798556" has
been scanned and inputted. I need the second one, when scanned to find
it's match and populate a cell on the same row. Is this possible to do
in Excel?

ANy help would be great!

Thanks!
:) :) :) :) :)


--
adamkane
------------------------------------------------------------------------
adamkane's Profile: http://www.excelforum.com/member.php...o&userid=29750
View this thread: http://www.excelforum.com/showthread...hreadid=494640