retrieve data from other file

  • Thread starter Thread starter toby
  • Start date Start date
T

toby

i 've a File A with diff. columns of data as showed:
A B C E F
no. name price size date
.... .. .. .. ..

so, how can i just enter the no. in other excel file B,
and then it can retrieve the data of column B, C, D etc.
from File A to the new excel B automatically ??!
thank you.
 
Select 5 cells horizontally in the B file with the leftmost file active,

=VLOOKUP(A2,[fileA.xls]Sheet1!$A$2:$F$2,{2,3,4,5,6},0)

enter with ctrl + shift & enter

then copy down
 
i've done so using this method, but none result. so wht's
the problem ? the cell just showed "#N/A".
anyone can help me?!
thankyou.

Toby
 
The #N/A tells you it didn't find the lookup value. It works for me,
try this, open both files, in the file where you want this done type

=A2='[fileA.xls]Sheet1'!A2

replace fileA with the name of your file and Sheet1 with the name of your
sheet,
if the result is FALSE the numbers are not exact, if TRUE the formula
should work. You can also use 5 formulas instead of 1 like this

=VLOOKUP(A2,'[fileA.xls]Sheet1'!A2:F100,2,0)

the above in B, now in C

=VLOOKUP(A2,'[fileA.xls]Sheet1'!A2:F100,3,0)

in D

=VLOOKUP(A2,'[fileA.xls]Sheet1'!A2:F100,4,0)

and so on, these can be entered normally
 
Back
Top