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

Find and Populate in Excel

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
Dee
Asked:
Dee
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

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

Open in new window

Regards
Find-n-Replace.xlsx
0
 
DeeAuthor Commented:
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
 
Saqib Husain, SyedEngineerCommented:
It is because the looked up numbers are not available in the raw data
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
DeeAuthor Commented:
???

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

Unless I am missing something else....
0
 
Rob HensonIT & Database AssistantCommented:
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
 
DeeAuthor Commented:
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
 
Rgonzo1971Commented:
You could also use

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

Open in new window

Regards
0
 
DeeAuthor Commented:
Thank you Rgonzo1971!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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