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
DeeAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
You could also use

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

Open in new window

Regards
0
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Saqib Husain, SyedEngineerCommented:
It is because the looked up numbers are not available in the raw data
0
 
DeeAuthor Commented:
???

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

Unless I am missing something else....
0
 
Rob HensonFinance AnalystCommented:
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
 
DeeAuthor Commented:
Thank you Rgonzo1971!
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.

All Courses

From novice to tech pro — start learning today.