Dear list,

I need some clues on this.  I have two excel files and I basically want
to map one to the other one. Can you give me some hints how to do
it?

The first excel file, named as "Susan_probe.xls", there are two columns,
"PROBE_ID1" and "SEARCH_KEY1"

  PROBE_ID1 SEARCH_KEY1  ILMN_30212 ILMN_30212  ILMN_1285 ILMN_1285
ILMN_137964 ILMN_137964  ILMN_138109 ILMN_138109 ...

The second excel file, named as "John_probe.xls", there are two columns as
well,
"PROBE_ID2" and "SEARCH_KEY2".

  PROBE_ID2 SEARCH_KEY2  ILMN_1809034 ILMN_16367  ILMN_1660305 ILMN_16583
ILMN_1792173 ILMN_19158 ...

There are 46713 rows in the first excel file and 49702 rows in the second
file.

Probes in the first columns of two excel files are different but they can be
matched
based on the second column "SEARCH_KEY". So what I want to do is to
substitute
the "PROBE_ID1" in the "Susan_probe.xls" file with the "PROBE_ID2" in the
"John_probe.xls" based on their common "SEARCH_KEY".

Thank you so much for your help. I really appreciate.

All the best,
      Allen

	[[alternative HTML version deleted]]

