=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.

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.