Looking up values and returning items into a calendar format.

I have used to Excel Query to resolve this issue before, but I was hoping someone could provide a formula combination for the calendar on the attached sheet that does not use queries. It seems that when you rename the file or someone forgets to save it in the right place, the queries naturally do not work. I do not know how to quickly change multiple queries to direct them to the right location. I am providing this to someone who may not save it in the sam eplace or may change the name of the file.

Issue: So, I was hoping that someone could show me a formula (on the attached Calendar sheet) that would look up on the master sheet all of the adjacent information for the the corrresponding goals on the master sheet within, lets say, the September 07 timeframe and list the required information. It would be great if it added a row to adjust if and when additional goals are added to the master. I guess I could use queries again if someone would explain how to quickly change the file source location and name (should it change or if it gets renamed), but it would be great if I could do it with formulae.

thanks so much!

Hi Eric,

Believe what you need is a lookup() which returns multiple answers ...
see previous thread

http://www.excelforum.com/showthread.php?t=581581

HTH
Carim

Carim:

I appreciate the reference. I found it helpful, but I do have one last question...

In my "sheets" zip file, I have a calendar with the following headings by month on the calendar page that require a similar information lookup as the one you showed me:

October 2006

Goal # Achieved Expectations Goal Owner Due Date

***empty rows

November 2006
Goal # Achieved Expectations Goal Owner Due Date

...etc

I know this is asking a lot, but is it possible that you could jot a note about what each part of the formula does. I'd like to get it to return multiple data values from the master sheet.

Again, I appreciate your time. I have used queries i nthe past, but they are very unstable...