Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If function that returns value in a cell.
I want to make an IF function that refers to a cell in another worksheet and
returns the value in that cell. All but the TRUE condition would be =if(cell0,,""} €¦ In other words, if the referenced cell has data in it, I want whatever data is there to be the result of the formula. How do I do this? -- ray |
#2
|
|||
|
|||
Let XL do the work for you.
Open both WBs. Start your formula: =IF( Then navigate to the other WB, and click in the cell that you wish to lookup. XL will add the path to your formula. Then, in the formula bar, add 0, OR <"", Then click in the cell *again* to repeat the path for the "True" condition. End off by adding the "False" condition to the formula bar ,"") OR ,"No Data") Then hit <Enter. Your formula might look something like this: =IF(Sheet3!A1<"",Sheet3!A1,"No Data") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "rayteach" wrote in message ... I want to make an IF function that refers to a cell in another worksheet and returns the value in that cell. All but the TRUE condition would be =if(cell0,,""} €¦ In other words, if the referenced cell has data in it, I want whatever data is there to be the result of the formula. How do I do this? -- ray |
#3
|
|||
|
|||
BTW,
You'll notice that when the Source WB is closed, the path in the formula might expand "greatly", depending on just exactly where (File, Folder, Directory, Drive) the Source WB is located. Also, every time you open the Target WB, you'll get a request to "Update Links", where you have the option to check the Source WB for new data, or to continue with the data at hand, from the "last" update. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... Let XL do the work for you. Open both WBs. Start your formula: =IF( Then navigate to the other WB, and click in the cell that you wish to lookup. XL will add the path to your formula. Then, in the formula bar, add 0, OR <"", Then click in the cell *again* to repeat the path for the "True" condition. End off by adding the "False" condition to the formula bar ,"") OR ,"No Data") Then hit <Enter. Your formula might look something like this: =IF(Sheet3!A1<"",Sheet3!A1,"No Data") -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "rayteach" wrote in message ... I want to make an IF function that refers to a cell in another worksheet and returns the value in that cell. All but the TRUE condition would be =if(cell0,,""} €¦ In other words, if the referenced cell has data in it, I want whatever data is there to be the result of the formula. How do I do this? -- ray |
#4
|
|||
|
|||
Thank you so much, Ragdyer - your formula worked perfectly.
-- ray "Ragdyer" wrote: Let XL do the work for you. Open both WBs. Start your formula: =IF( Then navigate to the other WB, and click in the cell that you wish to lookup. XL will add the path to your formula. Then, in the formula bar, add 0, OR <"", Then click in the cell *again* to repeat the path for the "True" condition. End off by adding the "False" condition to the formula bar ,"") OR ,"No Data") Then hit <Enter. Your formula might look something like this: =IF(Sheet3!A1<"",Sheet3!A1,"No Data") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "rayteach" wrote in message ... I want to make an IF function that refers to a cell in another worksheet and returns the value in that cell. All but the TRUE condition would be =if(cell0,,""} €¦ In other words, if the referenced cell has data in it, I want whatever data is there to be the result of the formula. How do I do this? -- ray |
#5
|
|||
|
|||
Thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "rayteach" wrote in message ... Thank you so much, Ragdyer - your formula worked perfectly. -- ray "Ragdyer" wrote: Let XL do the work for you. Open both WBs. Start your formula: =IF( Then navigate to the other WB, and click in the cell that you wish to lookup. XL will add the path to your formula. Then, in the formula bar, add 0, OR <"", Then click in the cell *again* to repeat the path for the "True" condition. End off by adding the "False" condition to the formula bar ,"") OR ,"No Data") Then hit <Enter. Your formula might look something like this: =IF(Sheet3!A1<"",Sheet3!A1,"No Data") -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "rayteach" wrote in message ... I want to make an IF function that refers to a cell in another worksheet and returns the value in that cell. All but the TRUE condition would be =if(cell0,,""} €¦ In other words, if the referenced cell has data in it, I want whatever data is there to be the result of the formula. How do I do this? -- ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Function to operate on ink linked to cell | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions |