Hi all.

I am looking to find out if there is any way (without using the Pivot
table feature) to do a Dynamic cell reference as part of a formula.


My worksheet has the following columns.
1. "Dates" ( individuals for all days of the month)
2. "Eng Name" for all dates and is at times sporadic
3. "Worked Items" # for all days worked
4. "Recieved"
5 "Sent"

Now, the problem is : I have about 3000 rows of information. I am
not sure how to write a vlookup with the dates as reference and then a
vlookup.

Simply Put. An engineer may appear in the table for some dynamic
number of times (which is usually unknown). I want to be able to lookup
wrked items etc for an engineer under a given date range (which I need
to calculate as it is going to be pretty dynamic and changes all the
while). Therefore for all the engineers.


Kindly mail me @ for any clarifications. I can
even fire the file i am working on. (Picture inserted)


Thanks a tonnne.


Ishti


--
IshtiaqM
------------------------------------------------------------------------
IshtiaqM's Profile: http://www.msusenet.com/member.php?userid=258
View this thread: http://www.msusenet.com/t-3340066