Linking Data according to names

lensman

New Member
Joined
Nov 21, 2005
Messages
4
Hallo, this is my first time here.

I basically have two seperate worksheets.

The one looks like this:
query.xls
BCDE
1CUST.COD.CUSTOMERLAB.CODELABNAME
2P450.001COLLEGEUNIVERSITY239LAB1
3P450.001COLLEGEUNIVERSITY533LAB2
4P450.001COLLEGEUNIVERSITY645LAB3
5P450.001COLLEGEUNIVERSITY423LAB4
6P450.001COLLEGEUNIVERSITY132LAB5
7P450.001COLLEGEUNIVERSITY455LAB6
8P450.001COLLEGEUNIVERSITY123LAB7
9P450.001COLLEGEUNIVERSITY542LAB8
10P450.001COLLEGEUNIVERSITY23LAB9
11P450.001COLLEGEUNIVERSITY65LAB10
12P450.001COLLEGEUNIVERSITY98LAB11
13P450.001COLLEGEUNIVERSITY421LAB12
14P450.001COLLEGEUNIVERSITY532LAB13
Sheet1


The other looks like this:
query.xls
CDEF
1LAB.CODEVALUE
2234324,89
3653234,65
49813213,89
5123435332,9
6132312312,7
72393432
842123423,9
942334321,65
1045523121,04
1153212312,9
125332312,67
13542342421,2
146453432,09
Sheet2


Basically the situation goes like this: I am not allowed to sort the data in the first worksheet. I am supposed to link the data that exists in the second one according to the lab code, so that the final document looks like this:
query.xls
BCDEF
1CUST.COD.CUSTOMERLAB.CODELABNAMEVALUE
2P450.001COLLEGEUNIVERSITY239LAB13432
3P450.001COLLEGEUNIVERSITY533LAB22312,67
4P450.001COLLEGEUNIVERSITY645LAB33432,09
5P450.001COLLEGEUNIVERSITY423LAB434321,65
6P450.001COLLEGEUNIVERSITY132LAB5312312,7
7P450.001COLLEGEUNIVERSITY455LAB623121,04
8P450.001COLLEGEUNIVERSITY123LAB7435332,9
9P450.001COLLEGEUNIVERSITY542LAB8342421,2
10P450.001COLLEGEUNIVERSITY23LAB94324,89
11P450.001COLLEGEUNIVERSITY65LAB103234,65
12P450.001COLLEGEUNIVERSITY98LAB1113213,89
13P450.001COLLEGEUNIVERSITY421LAB1223423,9
14P450.001COLLEGEUNIVERSITY532LAB1312312,9
Sheet1


Is there an easy way to do this?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
The problem is that I am not allowed to create a new worksheet and I can not edit the entry order. Another problem is that there are numerous subheadings, so creating a pivot table brings out a huge mess.

I have to somehow link the lab code in worksheet 1, to the lab code in worksheet 2 and have it display the value somehow.

Please, I am lost...
 
Upvote 0
No, they are not. The subcategories are related to the city where each client is located.

Basically I need a code that will check out the Lab.Code in worksheet 1, then look it up in Worksheet 2 and display the Lab Value right next to it.
 
Upvote 0
lensman said:
No, they are not. The subcategories are related to the city where each client is located.

Basically I need a code that will check out the Lab.Code in worksheet 1, then look it up in Worksheet 2 and display the Lab Value right next to it.

Is LAB.CODE on Sheet2 in ascending order? This is actually the question I wanted to pose.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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