View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Quimera Quimera is offline
external usenet poster
 
Posts: 24
Default 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