Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: Using dropdown list to select a lookup table

    I have multiple lookup tables, however the lookup information is identical in many circumstances, however I want use a dropdown list to dynamically change the lookup table, e.g.

    =vlookup(cell_ref,choice of range from list, column_number)

    Is this possible?

    to clarify, lets suppose I have 4 lookup ranges named, north, east, south, west.

    I want to be able to use a dropdown list to select the lookup range, and then all the applicable lookup formulas will then use than lookup range.

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Welcome to the Board!

    Something like this?

    Hope that helps,

    Smitty
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Posts
    3

    Further Example

    Many thanks for the welcome and help. I think we are on the way, here is an example that perhaps defines better what I want to do

  4. #4
    Join Date
    Feb 2004
    Posts
    3
    hmm didnt take file
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •