Lookup function?
 

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

Lookup function?
 

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Quimera" wrote in message
news:ovlEi.22591$Pd4.5833@edtnps82...
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

Lookup function?
 

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

Joan

"T. Valko" wrote in message
...
See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Quimera" wrote in message
news:ovlEi.22591$Pd4.5833@edtnps82...
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

Lookup function?
 

You're welcome!

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

--
Biff
Microsoft Excel MVP


"Quimera" wrote in message
news:1KCEi.40291$vP5.27022@edtnps90...
I am sure it will. Great website. Many thanks.

Joan

"T. Valko" wrote in message
...
See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Quimera" wrote in message
news:ovlEi.22591$Pd4.5833@edtnps82...
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