新聞財經娛樂♬資訊 News Economy

Hi Duncan

I'm out of time for today and will be working away from very early tomorrow morning until late Friday night, but will make a small version over the weekend to demonstrate my problem.

Thanks anyway, I will be in touch.

Bob

So you can create a copy for small-size workbook that can
simulate your issue, in other words, create a simple example
for experts in order to assist you when they understand your
issue. Now what I can do just find the function in the google
for your need for tutorial, for example ,this as follows, since
I could not understand what you need

Indirect() in VBA at http://www.cpearson.com/excel/indirect.htm

OR

To call other cell B1 in other workbook,  'APC Collections Notices.xlsm, at sheet of 'Week_27'  at A1 of EEpost.xls at sheet1 such as follows

A1='c: emp['APC Collections Notices.xlsm]week_27!$B$1'

You need to create simple or small-size example file and send us that will be faster to solve your issue
YOu don't need to send us the confident information, but you can similate it as simple example

The second item in vlookup is target  table array to be searched in  'APC Collections Notices.xlsm' workbook at variable worksheet, right ? what the range you want from example of  A1:A100 ,='c: emp['APC Collections Notices.xlsm]week_27!A1;A100', Right ?


Duncan

Hi Duncan

In the examples:

       A                                     B
1   Ref
2   128
3
4   Week_27      =VLOOKUP($A$2,'APC Collections Notices.xlsm'!A4,6,FALSE)
5   Week_27      =VLOOKUP($A$2,'APC Collections Notices.xlsm'!INDIRECT(A5),6,FALSE)

The information in cell A2 is 128. The formula has to lookup 128, column 6 in a range named Week_27 in the first example and Week_28 in the second example. The named ranges (Week_27 & Week_28) are both in a workbook called APC Collections Notices.xlms. Neither of the above versions work, but if I replace the A4 or A5 variables with the written text of Week_27 or Week_28, they work just fine. The examples are only the first column of many, which I want to copy down without physically having to change the Week_?? references, in each row. The workbook APC Collections Notices.xlms is huge, containing personal and confidential information, so I am unable to copy it to you. Thanks for any light you can shed on this.

Bob

Now we  would like to call   Excel cell in your previous post is  EEpost.xls at sheet1
and other workbook call  'APC Collections Notices.xlsm'

Could you send us the 'APC Collections Notices.xlsm' Excel  workbook ?

the reference for vlookup
http://www.techonthenet.com/excel/formulas/vlookup.php

 =VLOOKUP($A$2,'APC Collections Notices.xlsm'!INDIRECT(A4),6,FALSE)

where $A$2 is equa to 128, the second item in vlookup is table array you want to search 128, Right ?
what is table array range  in which workbook   ?
the third item is seach result at column index 6, right ? on which workbook ?

So please write more your question in detail that will be faster to solve the issue.

Up to this moment, I could not understand what you are solving for

Send us both of your workbook, EEpost.xls and  'APC Collections Notices.xlsm'
that will be easier to understand your question before finding out the solution

Duncan