Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Lookup

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am working with a price sheet on Worksheet 1, when I pick items on Worksheet 1 I would like to redirect that whole line to Worksheet 2 without ever effecting Worksheet 1. Is this possible? How would it work?

    Thanks for everyones input from past questions.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Methinks you would want VLOOKUP instead.

    If you've got a sheet of information on sheet 1, and you want a *picklist* on sheet 2, better thatn you use vlookup from sheet2 to find values on sheet1.

    There are examples of vlookup all over the place here. Do a search.

    Let me know if you have no luck.
    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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