Shane,
Thanks for the reply. In the end, I was making the formula too complicated.
F1 & J1 are dates and they are not needed as the required information is not
dependent on the dates. Sorry for the extra work.
Johnnie

"ShaneDevenshire" wrote:

Hi,

Replace your formula with this:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,SUM('[Revenue_Projection.xls]Dollar Forecast'!G5:H5,""))


--
Thanks,
Shane Devenshire


"Johnnie" wrote:

I am having a problem retrieving information from one worksheet to another.
This is the formula I am using:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,'[Revenue_Projection.xls]Dollar Forecast'!G5+H5,"")

I have also tried it this way:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,sum('[Revenue_Projection.xls]Dollar Forecast'!G5:H5),"")

I have confirmed that F1 and J4 match. Can you please advise me on why I am
not getting the information as requested.

Thanks for your help.

Johnnie