• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

Pulling Descriptions from another file

Hi

This is a follow up to my other question today

I have a series of numeric codes in column E of spreadsheet A  (i.e.  21 55 00 80 14 02 10).  I want to pull the description for these codes from spreadsheet B which also contains the codes and their associated descriptions

How would you approach this situation?  Would you use Open Database Connectivity (OBDC) to accomplish this is is there some better way to do this?

Thank You for looking at my question

Mike
0
BulldogMike
Asked:
BulldogMike
  • 6
  • 4
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Can you upload a very small sample file?
0
 
wdosanjosCommented:
I would use the VLOOKUP function.  Something like:
=VLOOKUP(A2,[YourOtherBook.xlsx]Sheet1!$C$2:$E$29,2,FALSE)

Open in new window


Using the VLookup Function in Excel 2007
http://msdn.microsoft.com/en-us/library/dd797422%28v=office.12%29.aspx

I hope this helps.
0
 
BulldogMikeAuthor Commented:
Here a sample file with a small spreadsheet
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Saqib Husain, SyedEngineerCommented:
Where?
0
 
BulldogMikeAuthor Commented:
Spreadsheet attached now

test spreadsheet attached
TEST-DGCL-21017-Analysis.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
Please also upload part of the file with codes and descriptions. You can fake the descriptions if the data is proprietary.
0
 
BulldogMikeAuthor Commented:
OK I have attached a revised spreadsheet (TEST-DGCL-21017-Analysis.xlsx) with the codes and added another (TEST-DGCL-GPI-NUM-01032012.xls) one that contains codes and descriptions.  

I had to revise the codes in the first spreadsheet so you would find the appropriate description in the second one

Thank You
TEST-DGCL-21017-Analysis.xlsx
TEST-DGCL-GPI-NUM-01032012.xls
0
 
Saqib Husain, SyedEngineerCommented:
Enter this formula in F1 and copy down

=VLOOKUP(E10,'[TEST-DGCL-GPI-NUM-01032012.xls]GPI-NUM-01032012'!$A:$D,4,0)
0
 
BulldogMikeAuthor Commented:
Here is what I have so far but it's not pulling the data - Please advise

=VLOOKUP(E10,'[CCM Adherence & Cyclic Chemo DGCLs Analysis.xlxs]GPI-NUM-01032012.xls'!$A:$D,4,0)

the files are:

1) CCM Adherence & Cyclic Chemo DGCLs Analysis.xlxs - just the codes which are in Column E

2) GPI-NUM-01032012.xls - codes are in column A and the descriptions are in column D


The files are in the same directory - please advise

Thanks

Mike
0
 
Saqib Husain, SyedEngineerCommented:
Are you able to make it work in the given sample files?

If you are doing this in another file the follow these steps
- Select the cell where you want to enter the formula
- type =VLOOKUP(
- Click on cell E10
- type the ,
- as soon as you have typed the comma select the columns a-d from the other file instead of typing the whole thing.
- then type ,4,0)
- then press enter


Edited
0
 
Saqib Husain, SyedEngineerCommented:
You need to provide sufficient feedback for the experts to help you. We cannot read your mind to know what is lacking in the response which deserves a B grade. If there is something more you want you can still ask further.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now