+ Reply to Thread
Results 1 to 4 of 4

Searching Item Code And Item Number

  1. #1
    Registered User
    Join Date
    07-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    80

    Searching Item Code And Item Number

    Hai Friends..

    In My attached file I want to search both Item Name as well as Item Number.. Please help me..

    Thanking You..
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Searching Item Code And Item Number

    Please try this file.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    07-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Searching Item Code And Item Number

    Thanks for replied..

    But Searching option is either item name or item code, if we search any one option, then another one should be blank. and item number should be start with "001".. the searching item number also be the first 3digit, for example
    It we search Plumbing item number that is 001 , if it is mechanical it should be 002 and so on..

  4. #4
    Registered User
    Join Date
    07-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Searching Item Code And Item Number

    Searching either Item name or item number

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-09-2013, 11:44 AM
  2. Taking the next item in a list into 1 of 2 tables based on the previous item time
    By SoleAris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:59 PM
  3. linking a list item or text item in a user form to a worksheet
    By ravergirl7216 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2010, 03:43 AM
  4. [SOLVED] Identifying an item in one col/row and searching an entire spreads
    By Bennie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  5. Identifying an item in one col/row and searching an entire spreads
    By Bennie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM

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