+ Reply to Thread
Results 1 to 2 of 2

Searching Column A and puting a check mark in Column B

  1. #1
    Registered User
    Join Date
    12-13-2006
    Posts
    1

    Searching Column A and puting a check mark in Column B

    Hi,

    I'm trying to make a simple function for my company for inventory purposes.
    Basically I have the numbers 1-320 down column A. I want to be able to scan with my scanner a serial number (all which will be a number 1-320) and have it find the number I scanned in the list and put a check mark (or an X or something) next to it in column B. Any ideas?

    Thanks,

    Ryan Smith
    Last edited by airhendrix13; 12-13-2006 at 05:11 PM.

  2. #2
    Forum Contributor
    Join Date
    09-28-2006
    Posts
    122
    assuming the result from the scanner is put into cell J1, then type the following formula into B1

    =IF(A1=$J$1,"x","")

    then formula fill down to B320, and an "x" will be in column b next to the cell that matches

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1