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