Lookup function?

[Quimera]

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

 

[T. Valko]

See if this helps:

http://contextures.com/xlFunctions02.html

 

[Quimera]

I am sure it will. Great website. Many thanks.

Joan

 

[T. Valko]

You're welcome!

And we can also thank Debra for maintaining such an informative site!