copy cell from one row based on cell from another row
 

Hi

Can anyone tell how to copy a cell from one row, based up information from
another row?

An example is the following:
A B C D E
Row 1 Test test2 test3 test4 test5
Row 2 yes

so the formula would look at Row 2, see that there is "yes" in cell C2 and
copy the text from row 1 (C1). There will only ever be one box filled in in
row 2

I'm using Excel 2003

Any help would be greatly appreciated!
Rachael

copy cell from one row based on cell from another row
 

=OFFSET(A1,0,MATCH("yes",2:2)-1)

--
Gary''s Student - gsnu200835

copy cell from one row based on cell from another row
 

Thank you! - I can't tell you how long I've been trying tofigure this out

"Gary''s Student" wrote:

=OFFSET(A1,0,MATCH("yes",2:2)-1)

--
Gary''s Student - gsnu200835