If e.g.Cell C2 (a code column) contains a code number, what formula can
be used in Cell D2 (a description column) that will LOOKUP(?) the code
in C2 on some sort of table or list and return the related description?
It is a long list of codes and related descriptions.

Thanks