Just make the "deliverables" and "deadlines" into a 2 column datalist, and
then access that list using a Vlookup formula like Niek suggested.

Say D1 to D12 on the Sheet "Lists" you have your deadlines.
In C1 to C12 enter your corresponding deliverables.

That gives you a datalist of C1 to D12.

Say your dropdown list is in E1 to E25 on your Main sheet.
Enter this formula in F1:

=IF(E5<"",IF(ISNA(MATCH(E5,Lists!$C$1:$C$12,0))," NoMatch",VLOOKUP(E5,Lists!
$C$1:$D$12,2,0)),"")

And copy down.


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bufossil" wrote in message
...
Hi Niek:

I have read the online help, and I guess I don't see how VLOOKUP() can help
me. I have 12 possible values for deliverables in one column, each of which
have their own (different) deadlines. If someone chooses a deliverable from
a drop-down list in column E, then I want the deadline to automatically
appear in column F. I have the deadlines listed in a column on a tab named
Lists. Does that make sense? So if someone selects "User Guide" from the
dropdown list in cell E5, then I want the deadline date [that resides in
cell
D4 on the Lists tab] to appear in cell F5.

The online help for VLOOKUP isn't very clear, but it doesn't look like it
can do what I would like for it to do. I will still need Excel to respond
to
a succession of 12 possible values in E5, and then fetch the respective
value
from a column on the Lists tab. I am misunderstanding something?

Thanks Niek!

"Niek Otten" wrote:

There is a limit of 7 nested IFs.
But it would be far better and easier to read if you used the VLOOKUP()
function.
Look in HELP for details, post again in this thread if you still have
problems.

--
Kind regards,

Niek Otten

"bufossil" wrote in message
...
I am listing a number of deliverables, and want the deadlines for those
deliverables to automatically appear in the next column (I have the
deadlines
on a tab named "Lists"). Unless I am misunderstanding something, there
is
a
limit of 7 successive IF-THEN statements you can use. Here is my
IF-THEN
formula:

=IF(E4="User Guide",'Lists'!D4,IF(E4="Installation",'Lists'!D5, IF(E4="HW
Upgrade",'Lists'!D3,IF(E4="Maintenance",'Lists'!D6 ,IF(E4="RAS
Trouble",'Lists'!D3,IF(E4="Online Help",'Lists'!D2,IF(E4="Site
Prep",'Lists'!D7,IF(E4="Inventry Sheet",'Lists'!D10,IF(E4="SW
Upgrade",'Lists'!D9,IF(E4="Release Notes","",IF(E4="Many or
All","",IF(E4="Other or N/A","",""))))))))))))

Excel will not let me use the formula because it has issues with the 8th
IF-THEN statement. My guess is that Excel can only handle 7. Does
anyone
know the limit you can use? I have 12 different values that have
different
deadlines. Thanks!