Lookup function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Quimera - 08 Sep 2007 00:52 GMT

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

Reply to this Message

T. Valko - 08 Sep 2007 03:19 GMT

See if this helps:

http://contextures.com/xlFunctions02.html

Signature

Biff
Microsoft Excel MVP

> 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

Reply to this Message

Quimera - 08 Sep 2007 20:29 GMT

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

Joan

> See if this helps:
>
[quoted text clipped - 6 lines]
>>
>> Thanks

Reply to this Message

T. Valko - 09 Sep 2007 04:25 GMT

You're welcome!

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

Signature

Biff
Microsoft Excel MVP

>I am sure it will. Great website. Many thanks.
>
[quoted text clipped - 10 lines]
>>>
>>> Thanks

Reply to this Message