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

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

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