+ Reply to Thread
Results 1 to 2 of 2

need help with data validation pls

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    18

    need help with data validation pls

    I have a sheet called 'codes list' and it has 2 tables. First is 'UACS' which contains codes like 0001, 0002, 0003, etc. and a second table called description which contains the equivalent description of the code. example 0001 - Repair and maintenance, 0002 - office supplies, 0003 - travel expenses, etc.
    Now i would like a dropdown in my main index sheet which the user will select from a dropdown a UACS code and the next column should reflect the description of that code. Anyone kind enough to help me? Thanks. I'm going to upload this on docs.google.com for others to encode so I'm not sure if any vba codes will work online.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: need help with data validation pls

    A2 - DV list of your codes
    B2 - INDEX(description_range,MATCH(A2,code_range,0))

    Better would be if you attach example excel file

+ 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: 01-14-2018, 11:04 AM
  2. Multi-select from data validation isn't working with auto-assigning data validation
    By iPenguin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2017, 12:37 PM
  3. Replies: 3
    Last Post: 06-04-2015, 02:27 PM
  4. [SOLVED] Data Validation: How to clear/delete the content of the cell and not Data Validation List?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2015, 09:42 AM
  5. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  6. Adding Date Data Validation to cells with List Data Validation
    By biggtyme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 09:47 AM
  7. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM

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