Hi all,

In an Excel document I have one worksheet "References" with in it a
list of references and a ref code (1 to about 500). In the other sheet
I have a dataset with for each observation a combination of references.
Every observation can have anywhere between 0 and 10 references. The
references for each observation are displayed horizontally, with in ech
cell a ref code (i.e. 3 in D1, 78 in E1, 232 in F1 for observation 1
and 34 in D45, 56 in E45 for observation 45).

Now, is there a way to replace the codes in the cells (1,2,3...) with
the actual references? Do I need a macro for this?

I would appreciate your help.

Arjen