+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP Help

  1. #1
    Registered User
    Join Date
    02-21-2005
    Posts
    2

    Red face VLOOKUP Help

    I am trying to Edit a Time Sheet for my business but im having Difficulty.

    Basically what im trying to do is this:

    I want to create a list of Text where each peice of Text is equal to a number, for example:

    Col.-------------Col.
    A----------------B
    Cat-------------10
    Dog------------20
    Mouse----------30
    Chicken--------40
    Hampster------50

    I then would like to set up a table that allows me to Use a Pulldown list to select either..... Cat, Dog, Mouse, Chicken or Hampster. And once ive made this selection it inputs a Number that corrisponds to that particular choice in another Column

    For example

    From a Column D, Dropdown list, ive chosen "Cat", now as a result of that, in Column E, Row 2, i would like the number "10" to automatically appear. And so on and so forth.

    I have already set up the dropdown list, and it works great, (note: i am using reference from inside the same workbook), however i do not know which function to use,(or how to use it) to generate that Automatic Number.

    Thank You in advance for your help
    Chris
    Last edited by cjbeck71081; 02-21-2005 at 01:40 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    The best solution would be to use INDEX. If the Combobox uses:
    - Input Range: $A$1:$A$20
    - Cell link: $D$1
    Then write the following in E1: =INDEX(B1:B20,D1)

    Ola Sandstrom

  3. #3
    Registered User
    Join Date
    02-21-2005
    Posts
    2
    Thank you for your response, but for some reason it isnt working out.

    Ive left a link on my webpage for you to view screenshots of the document,
    perhaps it will easier that way.

    www.epicri.com/cm/User.html

    I would like that E1 to read "10" when i select "Cat", "20" when i select "Dog" and so on.


    Thank You Again
    Chris

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Hmm, it should work. It works for me.
    Are you sure that Cell link: = $D$1
    This is the row under where you specified the Input Range: =$A$1:$A$20

    Ola


    Note:
    You can test if the cell link is there by enter 1 then 3 in D1. The shall change the display of the dropdownlist from "Cat" to "Mouse". And Index shall work with that.

+ 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