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