asked on

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

Rgonzo1971

Hi,

pls try

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

Open in new window

Regards
Find-n-Replace.xlsx

Dee

ASKER

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

Saqib Husain

It is because the looked up numbers are not available in the raw data

Dee

ASKER

???

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

Unless I am missing something else....

Rob Henson

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?

Dee

ASKER

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.

ASKER CERTIFIED SOLUTION

Rgonzo1971

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dee

ASKER

Thank you Rgonzo1971!