close
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
Something like:
=IF('[workbook1.xls]Sheet1'!A1='[workbook2.xls]Sheet1'!A1,'[workbook2.xls]Sheet1'!B1-'[workbook1.xls]Sheet1'!B1,quot;quot;)
HTH
JG
quot;RMD at JMUquot; wrote:
gt; How do I reference a cell in a different workbook so that I may use it in a
gt; formula?
gt; Ex. If Workbook 1 Column A = Workbook 2 Column A, then subtract Workbook 1
gt; column B from Workbook 2 column B.
gt; --
gt; RMD
全站熱搜
留言列表
