Here I go again, but different

TiggerToo · May 14th, 2002, 09:07 AM

here are two formulas, one that I now use and one I want to try using, so please read my mind and see how dumb I am at trying to accomplish something.

I am Using,
=if(sheet26!$c19=31,sheet26!$e19,if(sheet26!$c19=33,"H","")
As you can tell I am saying read column C row 19 is equal to 31, display column E row 19, (or) if column C row 19 is equal to 33 display H, or if neither matches display "".

But I want to display,
=if(sheet26!$a6:a33="f2+1" ,and sheet26!$c6:c33=31, sheet26!e6:e33,if(sheet26!$c19=33,"H","")
I want to be able to read column A6 to A33 and look for (the formula $f2+1) and also look in column C6 to C33 for the code 31 and then display whatever matches these codes form E6 to E33, but if code 31, OR if code 33 is matched display the leter H, or if neither matches display "".
I cannot figure out how to look in two columns for the EXACT match and if no match to code 31 or 33, display "".

Chris Davison · May 14th, 2002, 10:13 AM

Quote:

On 2002-05-14 08:07, TiggerToo wrote:
here are two formulas, one that I now use and one I want to try using, so please read my mind and see how dumb I am at trying to accomplish something.

I am Using,
=if(sheet26!$c19=31,sheet26!$e19,if(sheet26!$c19=33,"H","")
As you can tell I am saying read column C row 19 is equal to 31, display column E row 19, (or) if column C row 19 is equal to 33 display H, or if neither matches display "".

But I want to display,
=if(sheet26!$a6:a33="f2+1" ,and sheet26!$c6:c33=31, sheet26!e6:e33,if(sheet26!$c19=33,"H","")
I want to be able to read column A6 to A33 and look for (the formula $f2+1) and also look in column C6 to C33 for the code 31 and then display whatever matches these codes form E6 to E33, but if code 31, OR if code 33 is matched display the leter H, or if neither matches display "".
I cannot figure out how to look in two columns for the EXACT match and if no match to code 31 or 33, display "".

My cat's called "Tigger"

Aaaaaanyhow,

is the "f2+1" a text string, or are you wanting to check if that cell contains a formula of =F2+1, or you asking it to check if the cell is equal to F2+1

just trying to clarify before we launch into it

TiggerToo · May 14th, 2002, 10:56 AM

f2+1 equal and corresponds to a date formula,
like f2+1 is 13 May 2002 through F2+13 which is based on a 14 day pay period etc, etc,

TiggerToo · May 15th, 2002, 03:49 AM

Needing to Finish Formula,

here are two formulas, one that I now use and one I want to try using, so please read my mind and see how dumb I am at trying to accomplish something.

I am Using,
=if(sheet26!$c19=31,sheet26!$e19,if(sheet26!$c19=33,"H","")
As you can tell I am saying read column C row 19 is equal to 31, display column E row 19, (or) if column C row 19 is equal to 33 display H, or if neither matches display "".

But I want to display,
=if(sheet26!$a6:a33="f2+1" ,and sheet26!$c6:c33=31, sheet26!e6:e33,if(sheet26!$c19=33,"H","")
I want to be able to read column A6 to A33 and look for (the formula $f2+1) and also look in column C6 to C33 for the code 31 and then display what is in that row from E6 to E33. If the is 33 I want to display the leter H, and if neither matches display "".
I cannot figure out how to look in two columns for the EXACT match I want and if no match to code 31 or 33, to show a blank ("").

TiggerToo
Board Regular

Joined: Feb 27, 2002
Posts: 24
From: Macon, Georgia USA
Posted: 2002-05-14 09:56
--------------------------------------------------------------------------------
$f$2+1 is a date formula that I am using.
$f$2+1 is 13 May 2002 through F2+13 which is based on a 14 day pay period etc, etc,

Can someone try helping again.

inarbeth · May 15th, 2002, 06:50 AM

Can you explain what you are trying to achieve? I suspect the answer is straightforward and involves just the IF and possibly AND functions.

TiggerToo · May 15th, 2002, 08:27 AM

What I want, is to look in column A6 to A33 and find the formula ($f$2+1)(date formula) and look in column C6 to C33 for the number (31), and if both columns match then post whatever is in column (E6 to E33). If not number (31), I want to look in the same rows and columns for the number (33), next If number (33) is found, I want the letter ("H") inserted, instead of what is in cloumn (E6 to E33.) And then if neither number is found, do nothing ("").

thanks for trying
Walter

[ This Message was edited by: TiggerToo on 2002-05-15 13:20 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 09:07 AM	#1
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	here are two formulas, one that I now use and one I want to try using, so please read my mind and see how dumb I am at trying to accomplish something. I am Using, =if(sheet26!$c19=31,sheet26!$e19,if(sheet26!$c19=33,"H","") As you can tell I am saying read column C row 19 is equal to 31, display column E row 19, (or) if column C row 19 is equal to 33 display H, or if neither matches display "". But I want to display, =if(sheet26!$a6:a33="f2+1" ,and sheet26!$c6:c33=31, sheet26!e6:e33,if(sheet26!$c19=33,"H","") I want to be able to read column A6 to A33 and look for (the formula $f2+1) and also look in column C6 to C33 for the code 31 and then display whatever matches these codes form E6 to E33, but if code 31, OR if code 33 is matched display the leter H, or if neither matches display "". I cannot figure out how to look in two columns for the EXACT match and if no match to code 31 or 33, display "".

May 14th, 2002, 10:56 AM	#3
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	f2+1 equal and corresponds to a date formula, like f2+1 is 13 May 2002 through F2+13 which is based on a 14 day pay period etc, etc,

May 15th, 2002, 03:49 AM	#4
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	Needing to Finish Formula, here are two formulas, one that I now use and one I want to try using, so please read my mind and see how dumb I am at trying to accomplish something. I am Using, =if(sheet26!$c19=31,sheet26!$e19,if(sheet26!$c19=33,"H","") As you can tell I am saying read column C row 19 is equal to 31, display column E row 19, (or) if column C row 19 is equal to 33 display H, or if neither matches display "". But I want to display, =if(sheet26!$a6:a33="f2+1" ,and sheet26!$c6:c33=31, sheet26!e6:e33,if(sheet26!$c19=33,"H","") I want to be able to read column A6 to A33 and look for (the formula $f2+1) and also look in column C6 to C33 for the code 31 and then display what is in that row from E6 to E33. If the is 33 I want to display the leter H, and if neither matches display "". I cannot figure out how to look in two columns for the EXACT match I want and if no match to code 31 or 33, to show a blank (""). TiggerToo Board Regular Joined: Feb 27, 2002 Posts: 24 From: Macon, Georgia USA Posted: 2002-05-14 09:56 -------------------------------------------------------------------------------- $f$2+1 is a date formula that I am using. $f$2+1 is 13 May 2002 through F2+13 which is based on a 14 day pay period etc, etc, Can someone try helping again.

May 15th, 2002, 06:50 AM	#5
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	Can you explain what you are trying to achieve? I suspect the answer is straightforward and involves just the IF and possibly AND functions.

May 15th, 2002, 08:27 AM	#6
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	What I want, is to look in column A6 to A33 and find the formula ($f$2+1)(date formula) and look in column C6 to C33 for the number (31), and if both columns match then post whatever is in column (E6 to E33). If not number (31), I want to look in the same rows and columns for the number (33), next If number (33) is found, I want the letter ("H") inserted, instead of what is in cloumn (E6 to E33.) And then if neither number is found, do nothing (""). thanks for trying Walter [ This Message was edited by: TiggerToo on 2002-05-15 13:20 ]