copy cell from one row based on cell from another row

[rsmith]

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

 

[Gary''s Student]

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

 

[rsmith]

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