consolidate non-numerical data
 

Hi,

I have two (2) worksheets. I need to match the criteria of two columns, and
based upon that, import in the data and match the record.

For example, where the fields are mrn, and edvisitdate are equal for a
record in each wksheet, I want to import the data from the wk2 on field
program, and insert it into the field wk1.program.

any ideas?