LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find the second match using the match function Ray Excel Worksheet Functions 1 April 6th 09 10:19 PM
Find an exact match and go to that match Heath Excel Discussion (Misc queries) 0 February 12th 09 02:28 AM
Where is "open/tools/find/find files that match these criteria"? PJ Excel Discussion (Misc queries) 2 November 14th 08 04:11 PM
Find partial match from column A,B and fill partial match in C? Tacrier Excel Discussion (Misc queries) 4 October 24th 08 11:24 PM
Find Exact Match using INDEX, MATCH DoubleUU Excel Worksheet Functions 3 August 15th 08 02:42 PM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"