1. Registered User
Join Date
Sep 2008
Posts
150

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. Registered User
Join Date
Apr 2004
Location
Derbyshire, UK
Posts
803
=VLOOKUP(D2,'Workbook A.xls'!\$A\$2:\$C\$6,3,FALSE)

??

MTB

3. Registered User
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. Registered User
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. Registered User
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. Registered User
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. Registered User
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 04: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
•