|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2009, 01:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Formula
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 
|
|
#2
November 13th, 2009, 01:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
|
#3
November 13th, 2009, 01:49 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
|
#4
November 13th, 2009, 02:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
|
#5
November 13th, 2009, 02:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
|
#6
November 13th, 2009, 02:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
Post the formula you used
"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
|
|
#7
November 13th, 2009, 02:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
|
#8
November 13th, 2009, 02:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
=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
|
|
#9
November 13th, 2009, 03:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
|
#10
November 13th, 2009, 03:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Formula
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
