I have two worksheets with a common column. I want to combine the
information, however the columns aren't the same and I only need data from
one column.

For example:
A B C
Date Patient Virus
1/1/1900 00-100-1234 No Virus
1/2/1901 01-100-1245 RSV

In another worsheet I have the same information as in Column B and
additional information in column D. I want to match the patient information
from column B in both worksheets and add the information from column D into
the first worksheet to create one worksheet with one row of data. Any
thoughts? Thanks.

One way is to use a simple INDEX/MATCH ..

In Sheet1,

Put in D2:
=IF(ISNA(MATCH(B2,Sheet2!B:B,0)),"",INDEX(Sheet2!D :D,MATCH(B2,Sheet2!B:B,0)))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lost in Microbiology" wrote:
I have two worksheets with a common column. I want to combine the
information, however the columns aren't the same and I only need data from
one column.

For example:
A B C
Date Patient Virus
1/1/1900 00-100-1234 No Virus
1/2/1901 01-100-1245 RSV

In another worsheet I have the same information as in Column B and
additional information in column D. I want to match the patient information
from column B in both worksheets and add the information from column D into
the first worksheet to create one worksheet with one row of data. Any
thoughts? Thanks.

Hi

In D2 of Sheet1
=INDEX(Sheet2!D:D,MATCH(B2,Sheet2!B:B,0))

--
Regards
Roger Govier



"Lost in Microbiology" wrote
in message ...
I have two worksheets with a common column. I want to combine the
information, however the columns aren't the same and I only need data from
one column.

For example:
A B C
Date Patient Virus
1/1/1900 00-100-1234 No Virus
1/2/1901 01-100-1245 RSV

In another worsheet I have the same information as in Column B and
additional information in column D. I want to match the patient
information
from column B in both worksheets and add the information from column D
into
the first worksheet to create one worksheet with one row of data. Any
thoughts? Thanks.