Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: VLOOKUP within the same workbook???

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

    Default

    im trying to use vlookup within the same workbook (different worksheet) and i get nothing

    what i am doing
    =VLOOKUP(c2,'filename'!'cellname'3)

    any ideas???

    [ This Message was edited by: Orbit121 on 2002-04-11 00:55 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-11 00:48, Orbit121 wrote:
    im trying to use vlookup within the same workbook and i get nothing

    what i am doing
    =VLOOKUP(c2,'filename'!'cellname'3)

    any ideas???
    Your formula is incomplete:

    =VLOOKUP(lookup-value,lookup-table,column-num,match-type)

    is the syntax of the fuction.

    Try to find posts related to VLOOKUP by activating Search facility of this board. Consult also Excel's Help file.

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

    Default

    I'm not sure what you're trying to do but here is a formula that works:

    =VLOOKUP(B11,Suppliers!A2:B32,2,FALSE)

    "B11" contains a variable
    "Suppliers!A2:B32" contains the sheet name and range to lookup
    "2" is the what column you want returned
    "False" is an exact match

    Hope this helps

    Mark

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

    Default

    u try using the equal button located at the formula bar then follow the instruction to enter the lookup value, filename, cellname. give a try. excel can allow vlookup on the same work book.

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

    Default

    To everyone on here, thank you very very much, you all helped!!!!!!

    you guys kick some ***!

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    So Cal
    Posts
    379
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i find the easiest way to get vlookup to work with in same workbook is to add absolute reference:


    =VLOOKUP(c2,'filename$'$!'cellname'$3$)

  7. #7
    New Member
    Join Date
    Dec 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP within the same workbook???

    1
    Last edited by IST; Dec 17th, 2010 at 02:47 PM. Reason: Found out how to post as new thread

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

    Default Re: VLOOKUP within the same workbook???

    @markbanin i am following the sameway but when i came to worksheet refernce could be change. can u tell me the easy way..

    thanks in advance

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
  •