locate and match numerical values on 2 and copy text

[PeterCollins]

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.

 

[wideboydixon]

In B65 for example:

=IFERROR(INDEX(Sheet1!$D:$D,MATCH($O65,Sheet1!$E:$E,0)),"")

WBD

 

[PeterCollins]

Hi WBD, thanks for that. its not working for me yet but i will keep playing with it.

 

[PeterCollins]

got it working - well done. many thanks.