locate and match numerical values on 2 and copy text

PeterCollins

New Member
Joined
Sep 17, 2015
Messages
35
I'm having problems finishing some large geo-location information based spreadsheets ive been working on for months. I seem to have hit a problem on what appears a simple task compared to some of the other bits ive got it to do so far my attempts have failed and any help would be most gratefully recieved. Ive outlined the basic task and details below.

I’m trying to look up numerical values from one worksheet to locate them on another worksheet and then - when located - copy the text next to the located cell back to the first worksheet next to the queried numerical value.

The data is arranged as follows:

Worksheet 1
Source text is arranged in Column D, from rows 2 through to 300
Numerical data is arranged in Column E, from rows 2 through to 300

Worksheet 2
Contains a lot of retrieved data from a previous macro/formula
Column O has numerical data that identifies it to the list in worksheet 1

What I’m trying to do:
I need to write a quick formula that locates and finds a numerical match between worksheet 2/column O and worksheet 1/Column E and then copies the source text from worksheet 1/column D to worksheet 2/column B, copying it to the same row as the original queried number.

So, in practise if say the number 6 is located in worksheet 2/column O/row 65 - then the script looks up worksheet 1/column E and locates the corresponding number 6 which might be found in column E/row 4. It then copies the source text from worksheet 1/Column D/row 4 to worksheet 2/column B/row 65.

Anyones help would be very much appreciated - its driving me nuts.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top