+ Reply to Thread
Results 1 to 3 of 3

how to define dictionary to access by key?

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Poland
    MS-Off Ver
    Various
    Posts
    3

    Question how to define dictionary to access by key?

    Hello
    I have no idea how to solve my problem.
    I have dictionary defined as series of keys and let's say two values:
    name1,val1A,val1B
    name2,val2A,val2B
    ...and so on

    I would like to define named range from "name" column allowing user to select desired name from combo on another sheet.
    This is easy

    But after that I would like to get val1 and val2 for selected name and show them with some calculation;
    For example to construct two columns like this:
    <nameX_selected_from_combo>, (<val1X>+<val2X>)/2

    All the problem is how to select values from the same row as name selected in range.
    Anybody can help?

    Best regards for all.

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: how to define dictionary to access by key?

    Sure, can you post an example to add this to?

    You can use a basic Vlookup() or Index(Match()) combination to return the values. You probably don't need a combo box (can just use data validation from the Name column...)

    Hard to help more without an example workbook to install these ideas into
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    02-28-2014
    Location
    Poland
    MS-Off Ver
    Various
    Posts
    3

    Re: how to define dictionary to access by key?

    VLOOKUP() !
    Many thanks. That is exactly what I need

+ 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. list of 100,000 English words- is there a way to access Micrsoft's dictionary ex below.
    By azhar.sayed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2012, 12:57 AM
  2. error 1004 application define or object define
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-11-2011, 04:09 AM
  3. Nested dictionary items, how do you access them?
    By treyr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2010, 12:23 PM
  4. Define named range where user can define size
    By nahousto in forum Excel General
    Replies: 4
    Last Post: 07-06-2009, 05:09 PM
  5. Define User Access Levels to Workbooks
    By richardbairstow@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2006, 04:45 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