| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| lookup function | Excel Worksheet Functions | |||
| Lookup function help | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| lookup function 1 | Excel Worksheet Functions | |||
Hybrid Mode
