Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Help with my VLookup Please

    Hello Forum Friends,

    I am frustrated over my VLookup formula. Can someone please tell me what I am doing wrong? I am trying to pull date values from one workbook and put them into another workbook. Here is my formula.

    I am looking for the Inv Date in Workbook A to populate the Inv Date in Workbook B.


    =VLOOKUP(D2,'Workbook A.xls'!A2,2,FALSE)


    Workbook A
    A B
    1 Code Inv Date
    2 100 6/1/2012
    3 200 6/2/2012
    4 300 6/3/2012
    5 400 6/4/2012
    6 500 6/5/2012


    Workbook B
    D E
    1 Code Inv Date
    2 500
    3 400
    4 300
    5 200
    6 100

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    =VLOOKUP(D2,'Workbook A.xls'!$A$2:$C$6,3,FALSE)

    ??

    MTB

  3. #3
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    You need a sheet name in there too. The formula will be something like this:

    =VLOOKUP(D2,'[Workbook A.xls]SheetName'!$A$2:$B$6,2,0)

  4. #4
    Join Date
    Sep 2008
    Posts
    150
    Mike and Colin,

    Thank you both for your replies.

    I actually figured out what I was doing wrong in selecting the data in my array_table.

    I do have a question about alpha-numeric data. Does vLookup pick up alpha-numeric data or should I be using a differnet vLookup formula?

    I am trying to match an alpha-numeric project name (LA00023) to a numeric project location (10067044). I cannot get this to work.

    =VLOOKUP($K$3:$K$100,'[Project_Status_Sheet.xlsx]Status!$A2:$S100,2,FALSE)

  5. #5
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    You seem to be trying to look up 98 values ($K$3:$K$100) all in a single formula?

  6. #6
    Join Date
    Sep 2008
    Posts
    150
    Yeah, I was trying everything. Still get the same error even if I lookup 1 value ($K$3:$K$3).


  7. #7
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    VLOOKUP() can handle alpha numeric strings, so provided your look up value is exactly the same as the value in the left hand column of table_array, then it should find it.
    Perhaps there's a hidden space at the beginning or end of one of the strings?

    If not, perhaps you could attach an example to demonstrate the issue?
    Last edited by Colin Legg; 05-24-12 at 05:44.

Posting Permissions

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