Results 1 to 8 of 8

Problems Help! Drop Down List with similar name titles

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2006
    Posts
    10

    Problems Help! Drop Down List with similar name titles

    Hey guys...

    Im trying to make a list of multi Columns...Such as small example below

    NAMES ------ DIAMETER
    18KX ------------- 20
    20KX ------------- 30
    18WX ------------- 50
    20VS ------------- 10

    So i make a validation Cell for "Names", Then a "=LOOKUP" equation cell to reference the names to the "Diameters"

    BUT excel gets confused when i select a "NAME" that is similar to another such as 18KX and 18WX...so it just spits on the first on which is "20"

    i can do an IF statement instead of a LOOKUP statement but i have 200 "NAMES" & 200 "DIAMETERS"

    how can i do this?!?!?

    please help thanks guys!
    Last edited by caper; 11-07-2006 at 05:56 PM.

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