software

Hi there,

This question is torchering me many days:
I have two spreadsheets for the same patients. However these tables are
different but complementary to each other. Both spreadsheets have unique
Clinical Number.
Is it possible to match the information from these two tables by Clinical
number?

Ex:
Spreadsheet_1
ID Sample name Diagnosis Notes
123 RA234 ST RA Not for patient
456 RA456 TA GCA TA biopsy positive

Spreadsheet_2
ID Date of Birth Sampling Date Investigator Treatment
123 10/01/1960 10/10/2005 John Snow N/A
456 10/01/1955 N/A ----- -----

Thanks in advance
Daniel

Yes- use the Clinical Number as the argument in a VLOOKUP() function to
pull data from one data into the other.gt; I have two spreadsheets for the same patients. However these tables
gt; are different but complementary to each other. Both spreadsheets have
gt; unique Clinical Number.
gt; Is it possible to match the information from these two tables by
gt; Clinical number?
gt;
gt; Ex:
gt; Spreadsheet_1
gt; ID Sample name Diagnosis Notes
gt; 123 RA234 ST RA Not for patient
gt; 456 RA456 TA GCA TA biopsy positive
gt;
gt; Spreadsheet_2
gt; ID Date of Birth Sampling Date Investigator Treatment
gt; 123 10/01/1960 10/10/2005 John Snow N/A
gt; 456 10/01/1955 N/A ----- -----

One way is to use VLOOKUP. For example, Spreadsheet_1 could have a fifth
column for quot;Date of Birthquot;. In that column, the VLOOKUP function would pull
the value from Spreadsheet_2 by matching the ID.

There might be a third spreadsheet that pulls values from the first two in
a similar way.

Excel has built-in Help describing how to use VLOOKUP.

Daniel,

You can use the VLookup function to do this.
e.g. in spreadsheet_1 you add a 'date of birth' column next to the 'notes'
column
The formula for the first cell (ID 123) looks like this
=VLookup(A2,'[Spreadsheet_2]Sheet1'!$A:$E,2,false)
the function should look up ID 123 in column A of spreadsheet_2 (sheet1 if
that is where your data is), and then retrieve the value from the second
column of column range A:E if it matches exactly (false).

You can also lookup vlookup in the help funcion for more information.

--
Jeroen van Nieuwkerk

quot;usmleboyquot; wrote:

gt; Hi there,
gt;
gt; This question is torchering me many days:
gt; I have two spreadsheets for the same patients. However these tables are
gt; different but complementary to each other. Both spreadsheets have unique
gt; Clinical Number.
gt; Is it possible to match the information from these two tables by Clinical
gt; number?
gt;
gt; Ex:
gt; Spreadsheet_1
gt; ID Sample name Diagnosis Notes
gt; 123 RA234 ST RA Not for patient
gt; 456 RA456 TA GCA TA biopsy positive
gt;
gt; Spreadsheet_2
gt; ID Date of Birth Sampling Date Investigator Treatment
gt; 123 10/01/1960 10/10/2005 John Snow N/A
gt; 456 10/01/1955 N/A ----- -----
gt;
gt; Thanks in advance
gt; Daniel
gt;
gt;
gt;