How can I match two spreadsheets by patients ID?

[usmleboy]

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

 

[Dave O]

Yes- use the Clinical Number as the argument in a VLOOKUP() function to
pull data from one data into the other.

 

[Jay]

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 ----- -----

One way is to use VLOOKUP. For example, Spreadsheet_1 could have a fifth
column for "Date of Birth". 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.

 

[Jeroen]

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.