+ Reply to Thread
Results 1 to 3 of 3

Cell reference based on another cell choice from a drop down list.

  1. #1
    Registered User
    Join Date
    01-07-2010
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2003
    Posts
    8

    Cell reference based on another cell choice from a drop down list.

    I have a workbook that I have created that I want to use to show what area an address is located.

    I have 2 worksheets in the workbook
    -- Locations (I plan on hiding this)
    -- Site Lookup (which will be the main worksheet)

    on the locations worksheet i have 2 columns,
    column A - Sites -- which lists all the addresses
    column b - Areas -- which lists the area that the address is located in

    on the site look up worksheet
    Column a -- I have created a drop down listed based on the "sites" column from the locations work sheet
    Column b -- I want this to populate with the "area" that corresponds with the address that is chosen from the drop down list each time I choose a different address from column a.
    I have this vlookup: =VLOOKUP(Sites, Locations!A1:B255,2, FALSE), but when I choose a different address from the drop down menu, it doesn't change.

    I have attached my spreadsheet, hopefully it makes sense and someone can give some suggestions.

    Thanks,

    James
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Cell reference based on another cell choice from a drop down list.

    hi James, you are not supposed to lookup the whole "Sites". just A2 will do:
    =VLOOKUP(A2, Locations!A1:B255,2, FALSE)

  3. #3
    Registered User
    Join Date
    01-07-2010
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Cell reference based on another cell choice from a drop down list.

    Thanks, works great!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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