Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

I need to integrate data from 2 separate databases. If ...

Sent to Computer Experts November 29 11:26 AM

I need to integrate data from 2 separate databases. If one spreadsheet has data in one format and the other has data in another format and I need them to come together. I have seen this done with VLookup. I think it might work with MATCH, but I don't know how to do either one. HELP!

 

Optional Information:
OS: Windows XP; Browser: IE

Already Tried:
I'm just lost since I know it can be done in VLookup, but I do not know how to use that function

Customer (name blocked for privacy)
Status:  Closed   Value: $15
Answer
November 29 11:39 AM (12 minutes and 32 seconds later)
         
ACCEPTEDCheck Mark

Hello, Customer (name blocked for privacy).

I gather you are using Excel as a database?

If this is a question of mere format, you need only change the format of the cells. So I suspect it's a little more complicated than that. Could you give me examples of the format you want to change and the format you want to change TO?



Please reply if you have any problems.
*** If you find this post helpful, please click ACCEPT. And by leaving positive feedback, you give your Expert additional opportunities to earn Recognition. Thank you.
Picture
bytestream -- Computer Systems Analyst -- 99% Positive Feedback on 316 Computer Accepts
MSc, MCP; over 15 years of experience in all aspects of computing
Reply
November 29 11:54 AM (14 minutes and 56 seconds later)
         
I have one excel database with Last name, first name and then multiple lines of info (50,00 to be more correct)Each person in the second spreadsheet has many multiple entries in the first spreadsheet that needs to match to.

Then another spreadsheet with person's name and columns whether contractor or FTE and date of hire, etc. (approximately 200 lines)
I want to have both in a single spreadsheet so I can run pivots onthe total info.

Is it possible to send you 2 excel spreadsheets to show you?
Customer (name blocked for privacy)
Reply
November 29 11:57 AM (3 minutes and 1 second later)
         
I have one excel database with Last name, first name and then multiple lines of info (50,00 to be more correct)Each person in the second spreadsheet has many multiple entries in the first spreadsheet that needs to match to.

Then another spreadsheet with person's name and columns whether contractor or FTE and date of hire, etc. (approximately 200 lines)
I want to have both in a single spreadsheet so I can run pivots onthe total info.

Is it possible to send you 2 excel spreadsheets to show you?
Customer (name blocked for privacy)
Answer
November 29 1:14 PM (1 hour and 17 minutes and 25 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
bytestream -- Computer Systems Analyst -- 99% Positive Feedback on 316 Computer Accepts
MSc, MCP; over 15 years of experience in all aspects of computing
Reply
November 29 1:50 PM (36 minutes and 3 seconds later)
         

findithere

Tab 1 needs to integrate with tab 2. Could be vLookup, HHoolup or MATCH function. I don't know how to do these. Which would be ebst and can you guide me?

Customer (name blocked for privacy)
Answer
November 29 6:53 PM (5 hours and 2 minutes and 34 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
bytestream -- Computer Systems Analyst -- 99% Positive Feedback on 316 Computer Accepts
MSc, MCP; over 15 years of experience in all aspects of computing
Answer
November 29 10:59 PM (4 hours and 6 minutes and 24 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
bytestream -- Computer Systems Analyst -- 99% Positive Feedback on 316 Computer Accepts
MSc, MCP; over 15 years of experience in all aspects of computing
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer and Software Help