Function Difficulty
 

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

Function Difficulty
 

There is nothing wrong - it works for me
Try making formula using pointing method rather than typing:
1) Type =IF(F1=
2) Now click on the cell J4 in the second file
3) Type a comma and click on G5 in the second file (forget about H5 for the
moment)
4) complete the formula by typing
Does this work?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Johnnie" wrote in message
...
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

Function Difficulty
 

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

Function Difficulty
 

hi
do F1 and J4 contail decimal values??? if so...rounded to what?
your fomula works on my pc but i'm using hard numbers ie no decimals.
Regards
FSt1

"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

Function Difficulty
 

Bernard,
Thanks for the reply. Must be something screwy with my spreadsheets because
this did not work either. However, it is all irrelevant. I was making the
formula to complicated. F1 & J1 are dates and in the end they are not needed
as the required information is dependent on the dates. Sorry for the extra
work.
Johnnie



"Bernard Liengme" wrote:

There is nothing wrong - it works for me
Try making formula using pointing method rather than typing:
1) Type =IF(F1=
2) Now click on the cell J4 in the second file
3) Type a comma and click on G5 in the second file (forget about H5 for the
moment)
4) complete the formula by typing
Does this work?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Johnnie" wrote in message
...
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

Function Difficulty
 

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