DLookup or VLookup ??

[Crocdundee]

DLookup or VLookup ?????

Ok, let me try and work out this question in a way all of you will understand.
Using office 2007

I have 2 Xlsx files and I want to put the values from one column of the second file into a blank column in the first file
File names:

W2B.xlsx
UTAB.xlsx

W2B.xls receives the data in Col 13 M:M
UTAB.xlsx holds the data in Col 10 J:J

Both starts in row 2 ....allowing for the header
If u need the col names they are Points in the first file and Rating in the second file
Both files have a ID col and it resembles like the data below

40700NARR0101
40700NARR0102
40700NARR0103
40700NARR0104
40700NARR0105

--------------------
40700Narr0101
40700Narr0102
40700Narr0103
40700Narr0105

However you will notice that some rows are missing from the second file, such as 40700NARR0104
So in its place I guess a zero would do or delete the row from the first file

Both files reside in G:\Data\

Hoping someone can help here

Graham

 

[Marcelo Branco]

Hi Graham,

Assuming

Both files in G:\Data as you said

UTAB.xlsx
ID col = column A
values in column J beginning at row 2
Sheet containing data = Sheet1

W2B.xlsx
ID col = column A

Try this formula in M2 of relevant-sheet
=IFERROR(VLOOKUP(A2,[UTAB.xlsx]Sheet1!$A$2:$J$501,10,0),0)

HTH

M.

 

[Crocdundee]

Another hurdle achieved

Thanks very much for this learning curve, was really simple when you know how.
Appreciate your help, just had to delete one column ( really not important) in the second file but will practice that without the deleteing the column

Thank you for your Help
Graham

 

[Marcelo Branco]

Hi Graham,

You are welcome and tks for the feedback

M.