vlookup to another worksheet

[RobFJ]

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

 

[Pete_UK]

Something like this:

=VLOOKUP(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

 

[Eduardo]

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

 

[trip_to_tokyo]

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.