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