Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    lookup or vlookup using Excel 2010

    Hello-I am having a problem with the following vlookup formula. =Vlookup(b2,'c:user\data\[masterlog.xls]sheet1!'a1:d500,10, false). The value that is looking up in the masterlog.xls is in sheet1, column 10 and format can be number, general, text, etc.. When I run the formula I get a #N/A error. Am I using the wrong formula for this? Should i be using index or match formula? any help would be greatly appreciated. Thanks.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    If you are looking up B2 from column 10, that needs to be the FIRST column in your reference: A10:D500. Then, once B2 is found in the first column, you can extract data from another column.
    Last edited by RetiredGeek; 2013-11-02 at 20:02. Reason: Added noparse tags.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No I am looking up B2 from column 2 or b in sheet 1 masterlog.xls, but returning the value in column 10 that matches b2.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    This:
    =Vlookup(b2,'c:user\data\[masterlog.xls]sheet1!'a1:d500,10, false) is going to look in the first column (A) which is what VLOOKUP does.
    If you want to look up B2 in the second column of Sheet1, you need: =Vlookup(b2,'c:user\data\[masterlog.xls]sheet1!'B1:d500,10, false)
    Then, maybe need to change the 10 to an 11?

  5. #5
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. With your help I got the formula to work.

Posting Permissions

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