| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference to a range in another workbook
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic named range reference from external workbook | Excel Discussion (Misc queries) | |||
| Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook | Excel Discussion (Misc queries) | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Reference workbook name | Excel Worksheet Functions | |||
| Using a NAME as a reference in another range | Excel Discussion (Misc queries) | |||
Threaded Mode
