Formula help (solved again :))

[The Idea Dude]

Hi all,

I think this will be pretty easy to do, but I can't figure it out!!

I need to creat a formula for cell B5 that checks to see if cell A1="yes". If it does, then it will return the value of cell A2. If A1 does not equal "yes", then the formula will run the ceck on cell B2, and so on. I then need to be able to drag this equation downwards from cell B5.

So in the picture example, I will end up with a list like the YELLOW highlighetd cells, as opposed to the othe highlighted cells (which is what would happen from a simple "if" statement.

Thanks

Book2
	A	B	C	D	E	F	G	H
1		yes	yes	no	no	no	no	yes
2		hello	dog	cat	box	flower	rose	wet
3
4
5		hello		hello
6		dog		dog
7		wet
8
9
10
11				wet
12
Sheet1

This message was edited by The Idea Dude on 2002-09-09 01:57
This message was edited by The Idea Dude on 2002-09-09 02:35
This message was edited by The Idea Dude on 2002-09-09 18:54

 

[The Idea Dude]

That is fantastic andrew and Scott R.
This is a great help!