I have a filled column in worksheet_1 called "Reference". I have another 
empty column in that worksheet, called "Data" that I want to populate with 
values from worksheet_2.

Worksheet_2 has the necessary reference number to link to

My question is "how can I do a lookup on "Reference" in worksheet 1, pick up 
the same reference number in worksheet 2 and then do the vlookup on that to 
bring the correct data value over.

Thanks

Rob 

Something like this:

=3DVLOOKUP(Reference,worksheet_2!A:B,2,0)

then copy down. I've assumed that the data is in columns A and B of
your second sheet.

Hope this helps.

Pete

On Feb 8, 11:55=A0am, "RobFJ" <del**eteto**rfj1...@ntlworld.com> wrote:
> I have a filled column in worksheet_1 called "Reference". I have another
> empty column in that worksheet, called "Data" that I want to populate wit=
h
> values from worksheet_2.
>
> Worksheet_2 has the necessary reference number to link to
>
> My question is "how can I do a lookup on "Reference" in worksheet 1, pick=
 up
> the same reference number in worksheet 2 and then do the vlookup on that =
to
> bring the correct data value over.
>
> Thanks
>
> Rob

Hi,

I assume you have the reference number in column A then in worksheet 2 
reference number is in column A and data in column B

Change range to fit your needs

=Index(worksheet_2!$B$1:$B$1000,match(A2,worksheet_2!$A$1:$A$1000,0))

If this helps please click yes thanks

"RobFJ" wrote:

> I have a filled column in worksheet_1 called "Reference". I have another 
> empty column in that worksheet, called "Data" that I want to populate with 
> values from worksheet_2.
> 
> Worksheet_2 has the necessary reference number to link to
> 
> My question is "how can I do a lookup on "Reference" in worksheet 1, pick up 
> the same reference number in worksheet 2 and then do the vlookup on that to 
> bring the correct data value over.
> 
> Thanks
> 
> Rob 
> 
> .
> 

Hi Rob. 

I must admit I am not 100% clear on what you have said. 

However, I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 57 towards the top of my home page. 

I think that this gives you what you want (in EXCEL 2007) but am not 100% 
sure because, as I have said above, I am not 100% clear on what you have 
said. 

If my comments have helped please hit Yes. 

Thanks. 


"RobFJ" wrote:

> I have a filled column in worksheet_1 called "Reference". I have another 
> empty column in that worksheet, called "Data" that I want to populate with 
> values from worksheet_2.
> 
> Worksheet_2 has the necessary reference number to link to
> 
> My question is "how can I do a lookup on "Reference" in worksheet 1, pick up 
> the same reference number in worksheet 2 and then do the vlookup on that to 
> bring the correct data value over.
> 
> Thanks
> 
> Rob 
> 
> .
>