+ Reply to Thread
Results 1 to 6 of 6

using a pulldown as a match to pull data from another sheet.

  1. #1
    Registered User
    Join Date
    07-18-2019
    Location
    Phoenix, Arizona
    MS-Off Ver
    Office 365
    Posts
    4

    using a pulldown as a match to pull data from another sheet.

    HI,
    So I am having a problem with a function I am trying to do.
    Ok this is a workbook with 4 sheets.

    on the first sheet there is a pulldown in cell 12B that lists facilities by the town they are in

    formcap.PNG

    I want to pull data from a different sheet based on what is selected in that pulldown and populate 16B with the address

    The other sheet looks like this:
    Propcap.PNG

    as you can see 2 CDE make up the address. the Property column in the actual version matches the property name from the pulldown.
    I want to pull those 3 columns into text to populate the Street column (16B) on the first sheet.

    I can match and get a row #, I can index and get some weird results. But I cant get it to populate with the contents of those 3 cells as an address in the 16B cell

    Can anyone help me with this? Seems as if it should be easy, but I just cant get it.

    Hopefully this is a good enough explanation.

    Thanks in advance.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: using a pulldown as a match to pull data from another sheet.

    Hi, welcome to the forum

    Before I try and answer this, just want to point out a few naming conventions we use in excel.
    A cell is referred to by it's column letter (vertical) and row number (horizontal)
    the 16B cell
    Is called B16
    as you can see 2 CDE
    That would normally be referred to as C2:E2

    Ok, with that said, I cannot see, in table 2, any reference to Johnstown, so Im not sure how you are ID'ing that from your data I suggest that you To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-18-2019
    Location
    Phoenix, Arizona
    MS-Off Ver
    Office 365
    Posts
    4

    Re: using a pulldown as a match to pull data from another sheet.

    I put dummy information up in the second form to avoid violating HiPAA, just assume that prop1, prop2, etc are the property names.
    My bad on the syntax conventions. I don't do much outside of *nix unfortunately, bit of a cave in that sense. But it is noted and will be correct from now on.

    So if Johnstown said prop1 or vice versa, what would i do?
    keep in mind, thats a full drop down menu with many locations. but if you tell me the syntax of the functions or help me with it, I can put the specific data later.

  4. #4
    Registered User
    Join Date
    07-18-2019
    Location
    Phoenix, Arizona
    MS-Off Ver
    Office 365
    Posts
    4

    Re: using a pulldown as a match to pull data from another sheet.

    nm I got it

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: using a pulldown as a match to pull data from another sheet.

    Glad to hear you worked this out
    Care to share what you came up with?

  6. #6
    Registered User
    Join Date
    07-18-2019
    Location
    Phoenix, Arizona
    MS-Off Ver
    Office 365
    Posts
    4

    Re: using a pulldown as a match to pull data from another sheet.

    sure, but it's elementary.
    I made Cells on the main form for each of the individual aspects of the address.
    Then I just did an INDEX MATCH function to match for each individual Cell, instead of trying to concatenate them.

+ 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. [SOLVED] Pull whole rows of data to another sheet that match any of multiple criteria
    By christechgeek in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-12-2015, 03:51 AM
  2. Need Help: Pull Data from another Sheet using INDEX, MATCH functions etc
    By eummagic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2013, 01:45 AM
  3. Replies: 4
    Last Post: 08-29-2012, 10:32 AM
  4. [SOLVED] Match two columns (two sheets) to pull data into sheet 1
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2012, 05:51 PM
  5. Replies: 5
    Last Post: 07-26-2012, 09:51 AM
  6. [SOLVED] Pull data from another sheet if specified cells match
    By crystalblaker in forum Excel General
    Replies: 3
    Last Post: 07-25-2012, 11:21 AM
  7. Replies: 0
    Last Post: 01-23-2012, 02:49 PM

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