+ Reply to Thread
Results 1 to 6 of 6

Select value

  1. #1
    Forum Contributor
    Join Date
    12-11-2018
    Location
    Zurich
    MS-Off Ver
    2016
    Posts
    130

    Select value

    Hello again,

    im working on a database, programed in vba excel. What Im looking for is the following function: I do have a drop down menu, where I can pick out building names. Corresponding to this building names are values about this building (in the same line). Now I would like to be able to select the buildings over the drop down menu (with their name) and when I do that a value from row C is picked and written in a random excel cell. --> Look the matrix below for explanation(the whole this should be dynamic, means that if I put new buildings I can select them as well):

    building name / values
    A B C D E .....
    aa
    bb
    cc
    dd
    dd
    ...


    DROP-DOWN
    aa
    bb
    cc
    dd
    ...

    Formula --> gives me value from column C from the selected building (f.e. cc)

    I am happy for proposals with or without vba.

    Thank you!

    Matthias
    Last edited by travelkid; 12-12-2018 at 04:19 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Select value

    Without vba the formula you look for is probably VLOOKUP (with 4th argument equal FALSE).
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    12-11-2018
    Location
    Zurich
    MS-Off Ver
    2016
    Posts
    130

    Re: Select value

    okey thx, this seems like a start. I tried the following:

    =VLOOKUP(E15;A14:C17;3;FALSE)

    C4 = contains the name of the building im looking for
    A14:C17 --> corresponding table with building ans values that should be written out
    13= value from third column...(this value should be extracted, correct?)
    ...

    It is however not working. Instead of ; I tried commas, which does not work neither.

    Thanks for the reply!!
    Last edited by travelkid; 12-12-2018 at 07:00 AM.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Select value

    C4 is not used in your formula.

    I dont know what exactly hou have done, as the description is not self-consistent.

    See attached file
    Attached Files Attached Files

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Select value

    @ Kaper,

    And since when do you know formulas? Is VBA not your field of "Expertise"?

    Good show my friend!
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Select value

    Hi Winon,

    Sorry for OT answer to OT question :-)

    But when i first started exactly 10 years ago (Dec 12 2008) on excelforum.pl (the same nick) I was formula-only guy with some knowledge in graphs. 5 years ago, when I started on excelforum.com (Dec 14th 2013) I was already somewhat into VBA. But have not forgotten formulas. (Probably learned also quite some during these years).

    Anyway, thanks for nice comment.

    Best,

+ 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: 11
    Last Post: 11-03-2017, 05:11 AM
  2. Replies: 1
    Last Post: 08-18-2016, 03:17 AM
  3. [SOLVED] Select last row in column A and select 49 rows up, copy results to A2
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2016, 02:59 PM
  4. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  5. [SOLVED] Modify existing code to select file instead of select folder
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 09:41 AM
  6. Replies: 4
    Last Post: 06-17-2013, 05:21 AM
  7. Code to prevent user to Select COLUMNS but allow to select ROWS
    By tengrosita in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 03:46 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