+ Reply to Thread
Results 1 to 2 of 2

Data Validation without Drop-down list

  1. #1
    Registered User
    Join Date
    11-22-2018
    Location
    Baku
    MS-Off Ver
    Excel, Access, Word
    Posts
    2

    Post Data Validation without Drop-down list

    Hi All,

    Hope you all doing well.
    My question is " How to make data validation depending without dropdown list"
    I want to choose Item Description from dropdown list and for next column relevant code to appear automatically.
    For example:
    I have a table with 2 columns
    Column A - Item Description
    Column B - relevant codes

    Item Description CODE
    Table C003

    I did something similar with indirect function but it creates drop down list which I want to avoid.

    Thanks in advance

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Data Validation without Drop-down list

    If you looking for without drop down then you need to go for VB code to perform your task.

    Are you looking for something like this with Indirect function:
    https://www.contextures.com/xlDataVal02.html
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

+ 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: 3
    Last Post: 07-05-2015, 12:45 AM
  2. Replies: 0
    Last Post: 04-24-2015, 02:27 PM
  3. Replies: 5
    Last Post: 03-26-2015, 01:40 PM
  4. Drop Down List (Data Validation) Need to start at current value in list
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2014, 11:14 AM
  5. Data validation List: A macro to initiate drop down list?
    By dchubbock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2013, 08:12 PM
  6. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  7. Replies: 1
    Last Post: 07-08-2005, 11:05 AM

Tags for this Thread

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