excel 2 or more files then search

Asustek computer inc. / P5p800
October 22, 2011 at 15:17:19
Specs: Windows XP, P4 3GHz/ 2GB
1st. file: telephone number, minutes on line, costs
2nd file: telephone number, name

how to grab the name from the 2nd file and put it to the approp. cell in first file?
(key is phone number)

in old dbases it goes something like

select 1
use tn
select 2
use name index tn

then FIND command and so on...

See More: excel 2 or more files then search

October 22, 2011 at 17:22:51
If you have exact matches for the phone number in both files, you should be able to use VLOOKUP.

Read up on the VLOOKUP function in the Excel help files.



Book1.xlsx does not have to be open for the VLOOKUP to work.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 23, 2011 at 13:20:06


numb name
123 peter
234 donald
345 josephine
456 amanda
567 nigel
678 igor
789 miki
890 sven
901 barbara


A B=VLOOKUP(A1,[Phones.xlsx]
Sheet1! $A$1:$B$6,2,0)
123 or
456 =vlookup(A:A+[phones.xlsx]
789 not work :(

so to expect is in test.xlsx
123 peter
456 amanda
789 miki


Report •

October 23, 2011 at 17:01:51
First, it appears that you did not follow the instructions given in the last line of my response. Those instructions explain the proper way to post data in this forum. Please review the instructions found via that link before posting anymore data in this forum. That will make your example data easier to read thus making it easier for us to help you.

Second, keep in mind that we can not see your spreadsheet from where we are sitting. Telling us that something "doesn't work" does not give us a lot to work with. We don't know if that means that the formula returned an error or the wrong data or nothing at all, etc.

Instead of telling us that what you tried didn't work, tell us what actually happened so that we can try to determine why our suggestion did not work for you.

That said, I created a file called Phones.xlsx with this data:

     A	    B
1   numb   name
2   123	   peter
3   234	   donald
4   345	   josephine
5   456	   amanda
6   567	   nigel
7   678	   igor
8   789	   miki
9   890	   sven
10  901	   barbara

I then opened a new file and entered this:

       A         B
1     numb	name
2     123	=VLOOKUP(A2,[Phones.xlsx]Sheet1!$A$2:$B$10,2,0)
3     456	=VLOOKUP(A3,[Phones.xlsx]Sheet1!$A$2:$B$10,2,0)
4     789	=VLOOKUP(A4,[Phones.xlsx]Sheet1!$A$2:$B$10,2,0)

The result was this:

    A       B
1  numb	   name
2  123	   peter
3  456	   amanda
4  789	   miki

If you are not getting the same results, please supply some more details as to what is actually happening.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question