Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula difficulty | Excel Discussion (Misc queries) | |||
Difficulty with IMPOWER() Worksheet Function | Excel Worksheet Functions | |||
VLOOKUP Difficulty | Excel Discussion (Misc queries) | |||
difficulty with Search function that incorporates multiple workshe | Excel Discussion (Misc queries) | |||
Price Function - Difficulty in understanding the formula | Excel Worksheet Functions |