Simple Formula

Hi,
is the extention of the slowdownchart's workbook xlsx?

"Canon" wrote:

still no

"Mike H" wrote:

Try this

=IF(TRIM(A3)="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")

Mike

"Canon" wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two

yes

"Eduardo" wrote:

Hi,
is the extention of the slowdownchart's workbook xlsx?

"Canon" wrote:

still no

"Mike H" wrote:

Try this

=IF(TRIM(A3)="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")

Mike

"Canon" wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two

Does that mean that the cell looks empty?

I bet that if you retype Brent in A3, you'll see that it retrieves the value in
that external file.

ps. Check to see what's in B3 of Sheet1 of that slowdownchart.xlsx workbook.

pps. Do you have slowdownchart.xlsx open and are you using xl2007?


Canon wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two


--

Dave Peterson

Hi,
Mike formula should work, what does the formula return ?

try doing something, have the slowdownchart workbook open, and then in your
workbook enter in one cell = then select the cell you want the result from
and hit enter, if you got the number with this, highlight the formula, do
copy, go to Mike's formula and replace just the part within the first and 2nd
comma with this
tell me what happens thanks

"Canon" wrote:

yes

"Eduardo" wrote:

Hi,
is the extention of the slowdownchart's workbook xlsx?

"Canon" wrote:

still no

"Mike H" wrote:

Try this

=IF(TRIM(A3)="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")

Mike

"Canon" wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two

ppps. Make sure you have calculation turned to automatic.

Dave Peterson wrote:

Does that mean that the cell looks empty?

I bet that if you retype Brent in A3, you'll see that it retrieves the value in
that external file.

ps. Check to see what's in B3 of Sheet1 of that slowdownchart.xlsx workbook.

pps. Do you have slowdownchart.xlsx open and are you using xl2007?

Canon wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two


--

Dave Peterson

--

Dave Peterson

When I copy the formula, and press Enter, it brings up the Look in box and
shows;
Update Values: SlowDownChart.xlsx
When I cancel that, the cell shows #REF!

"Dave Peterson" wrote:

ppps. Make sure you have calculation turned to automatic.

Dave Peterson wrote:

Does that mean that the cell looks empty?

I bet that if you retype Brent in A3, you'll see that it retrieves the value in
that external file.

ps. Check to see what's in B3 of Sheet1 of that slowdownchart.xlsx workbook.

pps. Do you have slowdownchart.xlsx open and are you using xl2007?

Canon wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two


--

Dave Peterson

--

Dave Peterson
.

That means you don't have a file by that name--excel is asking you to locate
that file so that it can use it, too.



Canon wrote:

When I copy the formula, and press Enter, it brings up the Look in box and
shows;
Update Values: SlowDownChart.xlsx
When I cancel that, the cell shows #REF!

"Dave Peterson" wrote:

ppps. Make sure you have calculation turned to automatic.

Dave Peterson wrote:

Does that mean that the cell looks empty?

I bet that if you retype Brent in A3, you'll see that it retrieves the value in
that external file.

ps. Check to see what's in B3 of Sheet1 of that slowdownchart.xlsx workbook.

pps. Do you have slowdownchart.xlsx open and are you using xl2007?

Canon wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two


--

Dave Peterson

--

Dave Peterson
.


--

Dave Peterson

Yes, and you don't even need Sum. Just use:

=[Book2.xlsx]Sheet1!A1

Adjust the range to suit.

Regards,
Fred.

"Canon" wrote in message
...
Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount
in
cell A1 of workbook two

For some reason, this is not working on my system. Is something turned off?
Even if I open two new Excel books, I cannot grab the sum of a cell on the
other book, it looks like the formula does not follow when I click on the
other book.

"Dave Peterson" wrote:

That means you don't have a file by that name--excel is asking you to locate
that file so that it can use it, too.



Canon wrote:

When I copy the formula, and press Enter, it brings up the Look in box and
shows;
Update Values: SlowDownChart.xlsx
When I cancel that, the cell shows #REF!

"Dave Peterson" wrote:

ppps. Make sure you have calculation turned to automatic.

Dave Peterson wrote:

Does that mean that the cell looks empty?

I bet that if you retype Brent in A3, you'll see that it retrieves the value in
that external file.

ps. Check to see what's in B3 of Sheet1 of that slowdownchart.xlsx workbook.

pps. Do you have slowdownchart.xlsx open and are you using xl2007?

Canon wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two


--

Dave Peterson

--

Dave Peterson
.


--

Dave Peterson
.

Open both the receiving file and the sending file in the same instance of excel.

Select the cell in the sending file
Edit|copy (or ctrl-c)

Select the cell in the receiving file
Edit|paste special|paste link

You'll end up with a formula that has the correct syntax.

Once you get that portion working, you'll be able to add the =if() portion.

Or you'll be able to describe what problem happens next.

Canon wrote:

For some reason, this is not working on my system. Is something turned off?
Even if I open two new Excel books, I cannot grab the sum of a cell on the
other book, it looks like the formula does not follow when I click on the
other book.

"Dave Peterson" wrote:

That means you don't have a file by that name--excel is asking you to locate
that file so that it can use it, too.



Canon wrote:

When I copy the formula, and press Enter, it brings up the Look in box and
shows;
Update Values: SlowDownChart.xlsx
When I cancel that, the cell shows #REF!

"Dave Peterson" wrote:

ppps. Make sure you have calculation turned to automatic.

Dave Peterson wrote:

Does that mean that the cell looks empty?

I bet that if you retype Brent in A3, you'll see that it retrieves the value in
that external file.

ps. Check to see what's in B3 of Sheet1 of that slowdownchart.xlsx workbook.

pps. Do you have slowdownchart.xlsx open and are you using xl2007?

Canon wrote:

=IF(A3="Brent",[SlowDownChart.xlsx]Sheet1!$B$3,"")
This is the formula I used, (the cell numbers are correct), but it won't
return a value.

"Eduardo" wrote:

Hi,
check for any spaces in cell A1 before or after Brent, if there is any
delete them

"Canon" wrote:

Mike, for some reason this formula is not working for me.

"Mike H" wrote:

yes you can

"Canon" wrote:

Thanks Mike, can I just grab the information from the other workbook?
ie =sum(other workbook cell)

"Mike H" wrote:

Hi,

Try this with the file extension changed as required

=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")

Mike

"Canon" wrote:

Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of workbook two


--

Dave Peterson

--

Dave Peterson
.


--

Dave Peterson
.


--

Dave Peterson