skipping cells if criteria not met

[marshy3300]

Hi Peeps,

i have the following to display if yes is found in H3, show cell A3. Only problem is it leaves cells blank when a no if found.
Any idea how to have conseqitive yes names going down? I can't think of anything for the false statement. Perhaps a iserror in there as well?

=IF(ISNUMBER(SEARCH("*yes*",Questions!H3)),Questions!A3,"")

Cheers

 

[Tyron]

Hi Peeps,

i have the following to display if yes is found in H3, show cell A3. Only problem is it leaves cells blank when a no if found.
Any idea how to have conseqitive yes names going down? I can't think of anything for the false statement. Perhaps a iserror in there as well?

=IF(ISNUMBER(SEARCH("*yes*",Questions!H3)),Questions!A3,"")

Cheers

Hey marshy3300,

I am a bit confused.

Correct me if I am wrong.

Your goal is to display one value if the answer is yes and another value if the answer is no?

If that is the case then I would just use the following:

=IF(H3="yes", Questions!A3, IF(H3="no","The Answer is No", "Value Not Yes/No"))

If your value is selected from a drop down list then you don't have to worry about a third value and can just use:

=IF(H3="yes", Questions!A3, "The Answer is No")

Not sure why you would need to use the ISNUMBER and SEARCH, but that may just be because I don't see an example of your raw data from start to finish.

If this doesn't work use the advanced editor to create a mock worksheet with the table in "Go Advanced.

later

Ty

 

[marshy3300]

the "yes" is only part of the field not the whole cell, so im searching for it. Everytime it finds yes in column H I want a store name in A displayed. Only problem is it lists the names, but everytime a store says no, its a blank cell.
So scrolling down, it goes

Store
Store
store

store
store

store
etcetc

 

[Tyron]

Hello marshy3300,

Now it makes sense. Sorry about that. Is there a way you can show some pretend data so I can see what the formula is looking at?

later

Ty