Based on the earlier sample set up, for the selected code which appears in
the linked cell B2 in Sheet1

To extract the code description phrase elsewhere, use:
=IF(Sheet1!B2="","",INDEX(Sheet1!A:A,MATCH(Sheet2! B2,Sheet1!B:B,0)))

To repeat the selected code elsewhere, use:
=IF(Sheet2!B2="","",Sheet2!B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gayla" wrote in message
...
Thanks for the help. The only problem is the code descriptions will not
fit
on the same worksheet as the code. So what I was trying to do is on the
primary worksheet, the person see the drop down list or combo box
including
descriptions to choose their code. Only the code would populat that one
cell
and the code description would populate on the secondary worksheet.
Another idea I would consider is on the primary worksheet when they click
on
the cell to choose their code it would send them to the secondary
worksheet
cell where they could choose their code from the drop down box and then
populate the primary worksheet cell with the appropriate code based off
their
choice.
Either way will suffice. See example below. Thanks again for your help.

PRIMARY WORKSHEET
Col H

Delay?
Delay Code

Y
Delay Code would go here


SECONDARY WORKSHEET
Col H Col I Col J

Delay Code Days Delayed Delay Detail

CL03 3 Client - No Decision - Subject
Matter