Bernard, anyway to incorporate an hlookup type function as i will not know
which columns proj1 and its status will be in? The projects haven't been
input into the sheet yet. I'd like to set it up so that wherever the project
happens to be on the project tab, the summary tab finds the appropriate
status...

"Bernard Liengme" wrote:

On Sheet three starting in A1 I have three columns of text
apple dog blue
pear cat green
peach bird yellow
plum red
prune


On Sheet1 I have these formulas
=OFFSET(Sheet3!A:A,COUNTA(Sheet3!A:A)-1,0,1)
=OFFSET(Sheet3!B:B,COUNTA(Sheet3!B:B)-1,0,1)
=OFFSET(Sheet3!C:C,COUNTA(Sheet3!C:C)-1,0,1)
and they return, respectively
prune
bird
red

Hope you can adapt to your use
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Suzanne" wrote in message
...
Greetings. On one tab i have several projects (taking approx 6 columns
each),
each having several rows beneath with project steps. The project steps
each
have a corresponging Status colum (column to the right of the step).
I've constructed a summary tab that returns certain hi level data elements
for each project (using hlookup). However, i'd like to include a current
status column in the summary tab, for each project. Assuming the current
status is the last status listed in the status column, how to i return
that
value to the summary tab? Hope someone out there can help. Many thanks.

Formula for
summary tab this column? project tab
Start Status Proj1
Proj2
Proj1 2/1/07 On schedule Start: 2/1/07 Start:
3/3/07
Proj2 3/3/07 Behind schedule Step1: On schedule Step1:
Behind
schedule
Step2: Behind schedule
Step2: On schedule
Step3: On schedule
Step3: Behind schedule