LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 8th 17, 09:32 PM
Junior Member
First recorded activity by ExcelBanter: Sep 2017
Posts: 1
Default Best function to verify if a scanned barcode exists in a column.

The values are in column B and I want the ability to prompt true or false if a scanned data matrix exists in the list.

I have attempted to use VLOOKUP or ISNUMBER, but I am not doing something right.

I am basically scanning the data matrix's of hundreds of parts in a bin. My workbook has the list of values I want to keep, but the majority of these parts I will be trashing.

Last edited by LUTESLA : September 8th 17 at 11:08 PM

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
Scan pdf417 barcode = is scanned, actually tab data to next cell. David Gee[_2_] Excel Programming 1 August 24th 07 05:52 PM
Excel truncates barcode being scanned in BD Shipping Excel Discussion (Misc queries) 1 July 12th 07 08:11 PM
verify a shape exists in the sheet vandaley Excel Programming 3 October 29th 06 01:22 PM
verify a path exists JLGWhiz Excel Programming 13 August 24th 06 11:13 PM
Verify a directory exists MacroMan[_4_] Excel Programming 3 August 8th 03 04:38 PM

All times are GMT +1. The time now is 10:05 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017