Stumped with a formula

[TiggerToo]

Hello All,

I need a formula that looks in a different worksheet in column A for one item and then on the same sheet but different column C for another item and then gets the results from another column. something like this:
if(sheet01!A6:a33="f2+1, and sheet01!c6:c33=31,sheet01!e6:e33)
Hope you can see what I want or need.

I forgot but the rest of the results I want is: if A6 to A33 is not C31 or C33 I want to show blank ("")
This formula goes on the last sheet of my report and the results is shown the instant I change anyother sheet.
if(sheet01!a6:a33="f2+1",and sheet01!c6:c33=31,sheet01!e6:e33),if(sheet01!a6:a33="f2+1",sheet01!c6:c33=33,"H")"")

I am also looking for a if/or statement where if f2+1 is met then either 31 or 33 needs to be met and if/or neither is met I want a blank space to be shown.

This time I hope I explained it better.

[ This Message was edited by: TiggerToo on 2002-05-14 03:19 ]

[Audiojoe]

I don't quite understand what you want your result to be. If these conditions are met, what do you want to happen? Also, what do you want to happen if the conditions are not met? Do you want the cell to stay blank?

Audiojoe

[ This Message was edited by: Audiojoe on 2002-05-14 03:02 ]

[Mudface]

If I understand you right, would a variation on the following work for you: -

=IF(AND(Sheet2!A1=1,Sheet2!C1=2),Sheet2!E1,"")

The above will put the value in Sheet2E1 into the cell if A1=1 and C1=2, otherwise it'll insert a blank. You will obviously need to modify as necessary.