My data is arranged by department and under that there is a list of dates in
column a and the dates relate to the data in column b, the problem is that
all of these departments information is on one spreadsheet and if no data was
reported then that date doesn't appear on the spreadsheet. This means that
my function looks for the department and then compares the dates to a summary
spreadsheet and if no data was reported it keeps looking until it find the
date (like it looks into another department down the list) how can I tell the
function to stop looking when it runs into the word "department" again?

example:

Department Shoes
date data
date data
date data

Department Mens
date data
date data
date data

Department Womens
date data
date data
date data
date data

in the example above each word is in its own cell and the two columns are
right next to each other.

Any help would be much appreciated!

It would be best to restructure the data. Was that the point of your next
question?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dorn" wrote in message
...
My data is arranged by department and under that there is a list of dates
in
column a and the dates relate to the data in column b, the problem is that
all of these departments information is on one spreadsheet and if no data
was
reported then that date doesn't appear on the spreadsheet. This means
that
my function looks for the department and then compares the dates to a
summary
spreadsheet and if no data was reported it keeps looking until it find the
date (like it looks into another department down the list) how can I tell
the
function to stop looking when it runs into the word "department" again?

example:

Department Shoes
date data
date data
date data

Department Mens
date data
date data
date data

Department Womens
date data
date data
date data
date data

in the example above each word is in its own cell and the two columns are
right next to each other.

Any help would be much appreciated!

Unfortunately restructuring the data isn't really an option, its around 14000
rows with 150 departments and there isn't a set number of rows per
department, the only reference points are really the word "department" in its
own cell after one department ends and another begins. Is there a way to set
up a function to do something and if it reaches a certain cell content have
it stop looking and either leaves a blank or an error, anything would be fine
as long as it doesn't continue to pull data from another department down the
page. The other post was related to another project

"Bernard Liengme" wrote:

It would be best to restructure the data. Was that the point of your next
question?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dorn" wrote in message
...
My data is arranged by department and under that there is a list of dates
in
column a and the dates relate to the data in column b, the problem is that
all of these departments information is on one spreadsheet and if no data
was
reported then that date doesn't appear on the spreadsheet. This means
that
my function looks for the department and then compares the dates to a
summary
spreadsheet and if no data was reported it keeps looking until it find the
date (like it looks into another department down the list) how can I tell
the
function to stop looking when it runs into the word "department" again?

example:

Department Shoes
date data
date data
date data

Department Mens
date data
date data
date data

Department Womens
date data
date data
date data
date data

in the example above each word is in its own cell and the two columns are
right next to each other.

Any help would be much appreciated!