Populate one sheet with data from another based on matching column value

[thepinkgeologist]

So, I have a simple table with 5 columns ... "date" "well_number" "depth" "latitude" and "longitude"

And another table that has a "well_number" column (IDs for each well will map).

I want to populate the first table with a bunch of additional columns and data from the second where those IDs match (the second table will have many more well_number IDs than the 1st).

What is the most straightforward way to do this?

(see attached screenshot for tables)Attachment 418121

Thanks!

Added: Sorry, I think the figure is probably not helpful the way it is displayed)

[BadlySpelledBuoy]

Which columns do you with to feed from the second table into the first and into which columns?

BSB

[thepinkgeologist]

Well, I want to "add" the columns from table 2 to each matching well number in table 1 ... and there are quite a few ... (see list below)

These columns do not exist in table 1; I want to add them:

state_well_number county_code basin gma rwpa districtid previous_well_nu latitude lat_dec longitude long_dec owner_1 owner_2 driller_1 driller_2 source_of_coords aquifer_code aquifer_id1 aquifer_id2 aquifer_id3 elev_of_lsd meth_of_meas_elev user_code_econ date_drilled well_type well_depth source_of_depth type_of_lift type_of_power horsepower primary_water_use second_water_use tertia_water_use water_level_avail water_qual_avail well_logs_avail other_data_avail date_coll_or_updat reporting_agency well_sched_in_file construct_method completion casing_material screen_material todays_date user_name

[BadlySpelledBuoy]

Have a look at the attached for a very basic example of how to do this.

I've added INDEX/MATCH formulas to the yellow cells that will take the "State Well Number" and look that up in table 2. It then returns the corresponding data.

The formula in F4 is =INDEX(K:K,MATCH($B4,$J:$J,0)) . You just need to change K:K to match whichever column you want to look up from.
If the columns are in the right order already and without gaps between then you can just drag the formula to the right and down as needed.

Hope that points you in the right direction.

BSB

[newdoverman]

A picture is nice but no one can work with it.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[newdoverman]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.