Can anyone solve this problem

[TiggerToo]

Here is the Formula, what the problem is I do not know the right way to write it.

=if(and(sheet26!a6:a33=$f$2+1,sheet26!c6:c33=31),sheet26!e6:e33,if(and(sheet26!a6:a33=$f$2=1,sheet26!c6:c33=33,"H","")
Answer is: look down column A from 6 to 33, if $f$2+1 is found then look down column C from 6 to 33 for number 31, if found get results from column E from 6 to 33, if no match is found THEN look down column A again for same formula, if found then again look down column C from 6 to 33 for the number 33, if found make the results "H", and if neither is found do nothing and display ("") or blank.

I hope someone can write a good formula for me.
Thanks
Walter

See you in the moring.

[Juan Pablo González]

On 2002-05-15 19:04, TiggerToo wrote:
Here is the Formula, what the problem is I do not know the right way to write it.

=if(and(sheet26!a6:a33=$f$2+1,sheet26!c6:c33=31),sheet26!e6:e33,if(and(sheet26!a6:a33=$f$2=1,sheet26!c6:c33=33,"H","")
Answer is: look down column A from 6 to 33, if $f$2+1 is found then look down column C from 6 to 33 for number 31, if found get results from column E from 6 to 33, if no match is found THEN look down column A again for same formula, if found then again look down column C from 6 to 33 for the number 33, if found make the results "H", and if neither is found do nothing and display ("") or blank.

I hope someone can write a good formula for me.
Thanks
Walter

See you in the moring.

This is a strange request, specially this:

"I hope someone can write a good formula for me.
Thanks
Walter

See you in the moring."

What do you mean by this ? "if found get results from column E from 6 to 33" and also this "if found make the results "H""

[Yogi Anand]

On 2002-05-15 19:04, TiggerToo wrote:
Here is the Formula, what the problem is I do not know the right way to write it.

=if(and(sheet26!a6:a33=$f$2+1,sheet26!c6:c33=31),sheet26!e6:e33,if(and(sheet26!a6:a33=$f$2=1,sheet26!c6:c33=33,"H","")

Answer is: look down column A from 6 to 33, if $f$2+1 is found then look down column C from 6 to 33 for number 31,

For this expression so far, I believe you have to use AND, VLOOKUP, and IF functions

[/i]if found get results from column E from 6 to 33, if no match is found[/i]

For this part, it is not clear what is to be matched -- so one does not know what function(s) will be used for this part

THEN look down column A again for same formula, if found then again look down column C from 6 to 33 for the number 33, if found make the results "H", and if neither is found do nothing and display ("") or blank.

Here also I believe you have to use AND, VLOOKUP, and IF functions.

I hope someone can write a good formula for me.
Thanks
Walter
See you in the moring.

Now you should write the formula yourself. If some one wrote it for you, you will miss out on the learning experience. Once you put the effort in, and there is something you have difficulty with, people on the board will have you resolve the problem. This way you will learn as well as enjoy the process.

Regards!

_________________
Yogi Anand
Edit: Deleted inactive web site reference from hard code signature line

[ This Message was edited by: Yogi Anand on 2003-01-19 17:07 ]