Solved

Find and Populate in Excel

Posted on 2016-07-19
10
34 Views
Last Modified: 2016-08-15
Isn't there a way I can look up values in one spreadsheet to populate values in another spreadsheet?

I want to populate the areas associated with owners on the FORMATTED DATA tab.  The owner area information is located on the RAW DATA tab.

Thank you,
Find-n-Replace.xlsx
0
Comment
Question by:Dee
10 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 41719152
Hi,

pls try

=VLOOKUP(D2,'Raw data'!C:D,2,0)

Open in new window

Regards
Find-n-Replace.xlsx
0
 

Author Comment

by:Dee
ID: 41719198
Thank you!  It works fine on the sample file but fails on an actual data set.  (data set attached).

Any ideas?
Find-n-Replace---Data-set.xlsx
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 41719220
It is because the looked up numbers are not available in the raw data
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:Dee
ID: 41719239
???

The very first number (105049276) is on row 295 in the raw data tab....

Unless I am missing something else....
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 41719261
The values on Raw Data tab are text strings that look like numbers, presumably downloaded from some other system that has exported as text.

Try this instead:
=VLOOKUP(TEXT(C2,"0"),Raw!A:B,2,0)

I notice on your Formatted sheet the values in column C are repeated several times, the one quoted above all the way down to row 137. Putting the lookup above in column B will repeat the same value retrieved from the lookup. Are you expecting different values?
0
 

Author Comment

by:Dee
ID: 41719386
AH!!!!!!  Yes, that must have been it.  The text conversion works fine!  Yes we are expecting the same value multiple times throughout the formatted results.

Thank you again for the nice solution.
0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41719415
You could also use

=VLOOKUP(""&C2,Raw!A:B,2,0)

Open in new window

Regards
0
 

Author Comment

by:Dee
ID: 41719444
Thank you Rgonzo1971!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question