I have a worksheet called "master" that includes a column called
"identifier" which is an ID name. There are several occurrences of each
"identifier" value in the column. I have another worksheet called "dams" that
contains the same "identifier" column, but with only one occurrence of each
"identifier" value in the column. The only data in common between the two
worksheets is the "identifier" column. I would like to merge the two
worksheets by having excel match the "identifier" name in the two worksheets
and transfer the associated cells in each the row from the "dams" worksheet
to the "master" worksheet. This will result in an addition of several columns
of data to the "master" worksheet from the "dams" worksheet.

Seems that there must be a simple way to do this, but I have not been able
to figure it out (I am not too experienced in Excel). I tried the
"consolidate" feature, but that seems to be limited to numerical formulae,
and I just want to transfer text from each cell.
--
A Ford