Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: V-lookup

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

    Default

    I need help with an assignment. I am trying to use v-lookup. the file that I am using is at http://www.business.utah.edu/~sonja/...am/prducts.xls, I know how to name the table, but it is just really stumping me. Can you please help.? I also need to know how to change the file so that the formulas show instead of the #'s . Thanks for the help

  2. #2
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    812
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    File link requires password.

    I will try to answer when i see the file.

    By the way: if you need VLookup basics

    http://www.thewordexpert.com/excel.h...DreadedVlookup

    regards

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The password is spring, spring. I think, thanks again for the help.

  4. #4
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    812
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    spring
    spring, spring
    spring, spring.

    none of them. And also need a user name.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    To show formulas rather than the results of formulas, go on the menu to Tools|Options|View and then put a check in the Formulas box.

    Keep in mind that this will change the layout of your spreadsheet somewhat, as columns will expand to display the entire formula in each cell.

    _________________
    Regards, Duane

    [ This Message was edited by: Duane on 2002-04-07 07:52 ]

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just wanted to say thanks to both of you, the info was extremly helpful and the v lookup link answered my problem I really appriciate the help.

  7. #7
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    812
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nice to hear that.

    Anytime.


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
  •