combining data

D

Dr. Harvey Waxman

I have two worksheets (2005) and (2006) with similar data headings

Column A has unique identifiers for each row in both sheets.

I'd like to capture information from every entry in 2005 columns D,E,F and copy
to columns D.E,F in the corresponding row in 2006.

If there is no corresponding entry in 2006 I'd just skip it and move to the
next row.

What formulas go in (2006) D,E,F?

Seems like some sort of an array needs to be used to capture the identifiers
but I don't see how to then pick the corresponding data in the proper row to
copy over.

It might be too confusing.
 
H

Harvey Waxman

Regarding my last post. I tried a vlookup function which looks like it will
work but:

1. How can I avoid the #NA's? I'd like the cells to be blank.
2. The calculation looks like it will take an hour (33000 rows to lookup)

Is there something wrong here?
 
Top