referencing cells in different workbooks

[jandrews]

HELP! I have two different workbooks, and I am referencing cells in one
workbook (call it test1) to another workbook (call it test2). I want the cell
in workbook test2 that contains the referenced cell from workbook test1 to
keep the same cell reference after I sort the workbook test1. For instance,
if the formula in workbook test2 contains ='[test1.xls]Sheet2'!$G$33, and
after sorting workbook test1 that same cell now is in,say G56, I want the
reference in workbook test2 to follow to the new cell adress in workbook
test1. What can I do to acomplish this?

 

[Marcelo]

INDIRECT(ADDRESS(13,4,1,1,"test1"))

use the this function on test2 sheet,

Assuming you are looking for the result on the D13 cell of test1 sheet

the 13 on the function is the row
the 4 on the function is the column A=1; D=4


hth
--

regards from Brazil
Thanks in advance for your feedback.
Marcelo



"jandrews" escreveu:

 

[Don]

is the one you are looking up a table? then maybe you can use the VLookup
command. If they are numbers , then maybe the sumif?