Reference to a range in another workbook
Huyeote
If your not familiar with Visual basic you can use an
indirect.ext worksheet function which allow's you to use
references to external workbooks closed or open.
You'd need to add an additional add inn for this function
so if you'd like it let me know
Rgds
Aaron
-----Original Message-----
Hi, there, I need to insert a VLOOKUP formula to a range
of cells in a
worksheet in workbook1. The looked up area is a range in
workbook2. The
formula string looks like "=VLOOKUP(RC[-1],
'[Workbook2]Sheet1!R1C1:R55C7',8,FALSE". The address of
the looked up area
changes frequently. How can I use a variable to replace
the long string of
the address? How many ways to do it? Thanks in advance.
Regards
Huyeote
.
|