Thanks for the help. I just about have it. The only thing not working is on
my primary worksheet where they choose the appropriate code but at the same
time being able to view the descriptions as well. I only want the code left
listed on that worksheet (primary) in that cell not the description. It is
currently leaving the description listed not the code. I got the secondary
worksheet to work great!
Is there something I am missing?

My primary worksheet is 'Daily-PM'! , cell I want the code in is I8


My source data is Codes!A2:B7

My secondary worksheet is Delays! cell for description is J6 and cell for
code is H6.

Primary Worksheet - I have combo box with:
ListFillRange: Codes!A2:B7
LinkedCell: I8
BoundColumn: 2
ColumnCount: 2
ColumnWidths: 250 pt;60 pt

Here are my formulas:

In J6 -
=IF('Daily-PM'!I8="","",INDEX(Codes!A:A,MATCH('Daily-PM'!I8,Codes!B:B,0)))

In H6 - =IF('Daily-PM'!I8="","",'Daily-PM'!I8)

Thanks.

"Max" wrote:

Some typos in earlier response, sorry, it should have read as:
------
Based on the earlier sample set up, for the selected code which appears in
the linked cell B2 in Sheet2

To extract the code description phrase elsewhere, use:
=IF(Sheet2!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
---