var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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
1 Code Inv Date
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)
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.
You seem to be trying to look up 98 values ($K$3:$K$100) all in a single formula?
Yeah, I was trying everything. Still get the same error even if I lookup 1 value ($K$3:$K$3).
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