If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup to another worksheet
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 |
#2
|
|||
|
|||
vlookup to another worksheet
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 On Feb 8, 11:55*am, "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 |
#3
|
|||
|
|||
vlookup to another worksheet
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 . |
#4
|
|||
|
|||
vlookup to another worksheet
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 . |
Thread Tools | |
Display Modes | |
|
|