Thank you so much Niek. That worked perfectly. I really appreciate the help
you guys provide.

"Niek Otten" wrote:

=VLOOKUP(C11,Sheet2!C1:E91,3,FALSE)

Or, if you don't like the #NA if there is no matching date,

=IF(ISNA(VLOOKUP(C11,Sheet2!C1:E91,3,FALSE)),"",VL OOKUP(C11,Sheet2!C1:E91,3,FALSE))

--
Kind regards,

Niek Otten

"Joker" wrote in message
...
Is there anyway to shorten an IF formula? What I am trying to do is
display a
certain number that coinsides with the date. Here is the formula that I am
currently using. It works but it is too long and the "Formula Is Too Long"
error pops up when I have too many days.
=IF(C11=Sheet2!C1,Sheet2!E1,0)+IF(C11=Sheet2!C2,Sh eet2!E2,0)+IF(C11=Sheet2!C3,Sheet2!E3,0).
In the first part of the formula C11 is today's date. Sheet2!C1 is any
date.
Sheet2!E1 is a number. I need a the cell to display the number if today's
date matches the date on the Sheet2. Sheet2 has 91 days to display. Thank
you
for your help.