DLookup or VLookup ??

C

Crocdundee

Board Regular
Joined
May 10, 2010
Messages
174
Office Version
  1. 2013
Platform
  1. Windows
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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
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.
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Locked
  • Question
find a value in two w/book sheets for value exists or not - vba code
Replies
1
Views
284
Fluff
Fluff
K
  • Solved
Compare multiple columns in 2 workbook's different worksheet, then copy and past values
Replies
2
Views
854
sijpie
sijpie
L
  • Question
Vlookup and Replace if match found VBA
Replies
6
Views
715
Alex Blakenburg
A
R
  • Question
Formatting using VBA
Replies
0
Views
419
RandyD123
R
M
  • Question
Creation of Results Table + Hiding of Sheets and Columns
Replies
1
Views
385
MelissaBr
M

Forum statistics

Threads
1,214,945
Messages
6,122,395
Members
449,081
Latest member
JAMES KECULAH

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top