ExcelBanter - Column Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Column Reference (https://www.excelbanter.com/excel-discussion-misc-queries/69332-column-reference.html)

RMD at JMU

Column Reference

How do I reference a cell in a different workbook so that I may use it in a
formula?
Ex. If Workbook 1 Column A = Workbook 2 Column A, then subtract Workbook 1
column B from Workbook 2 column B.
--
RMD

pinmaster

Column Reference

Something like:

=IF('[workbook1.xls]Sheet1'!A1='[workbook2.xls]Sheet1'!A1,'[workbook2.xls]Sheet1'!B1-'[workbook1.xls]Sheet1'!B1,"")

HTH
JG

"RMD at JMU" wrote:

How do I reference a cell in a different workbook so that I may use it in a
formula?
Ex. If Workbook 1 Column A = Workbook 2 Column A, then subtract Workbook 1
column B from Workbook 2 column B.
--
RMD

All times are GMT +1. The time now is 09:05 PM.