Add to formula

I want to add to the following formula a condition if PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave cell empty.

{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))
,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in the range
(i.e., "apple" would count also), again for all cells or any one cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave cell empty.


{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))
,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in the range
(i.e., "apple" would count also), again for all cells or any one cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave cell
empty.



{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))
,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in the range
(i.e., "apple" would count also), again for all cells or any one cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave cell
empty.




{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))
,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

Here is the formula when adjusted. It does not return a value as expected,
although there is no errors appearing.

=IF(COUNTIF(PO04!T24:T1500,"E"),IF(ISERROR(INDEX(P O04!$L$24:$L$1500,MATCH(PC
!$H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24 :$L$1500,MATCH(PC!$H8,PO04
!$AI$24:$AI$1500,0))),"")

Because PO04!T24:T1500 is formmated to either TRUE or FALSE ("E" being TRUE
and "S" being FALSE) when the formula is adjusted to reflect this for eg.

=IF(COUNTIF(PO04!T24:T1500,1),IF(ISERROR(INDEX(PO0 4!$L$24:$L$1500,MATCH(PC!$
H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24:$ L$1500,MATCH(PC!$H8,PO04!$
AI$24:$AI$1500,0))),"")

a value is returned. The only problem now is that a value will return for a
given cell both if 1(one) or 0 (zero) is used in the same formula.

I hope you can understand where I am coming from!
Pat





"Dave R." wrote in message
...
=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in the
range
(i.e., "apple" would count also), again for all cells or any one cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave cell
empty.





{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))
,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

You just need to figure out what is actually contained in those cells
(t24:t1500). go to some generally formatted cell and enter =T24 , and see
what comes up. Also see what comes up on cells that are the opposite
(true/false), and use that in the COUNTIF part.

Of course if there is at least one 0 and one 1 in that range, the formula
will return the same thing.




"Pat" wrote in message
...
Here is the formula when adjusted. It does not return a value as expected,
although there is no errors appearing.


=IF(COUNTIF(PO04!T24:T1500,"E"),IF(ISERROR(INDEX(P O04!$L$24:$L$1500,MATCH(PC

!$H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24 :$L$1500,MATCH(PC!$H8,PO04
!$AI$24:$AI$1500,0))),"")

Because PO04!T24:T1500 is formmated to either TRUE or FALSE ("E" being
TRUE
and "S" being FALSE) when the formula is adjusted to reflect this for eg.


=IF(COUNTIF(PO04!T24:T1500,1),IF(ISERROR(INDEX(PO0 4!$L$24:$L$1500,MATCH(PC!$

H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24:$ L$1500,MATCH(PC!$H8,PO04!$
AI$24:$AI$1500,0))),"")

a value is returned. The only problem now is that a value will return for
a
given cell both if 1(one) or 0 (zero) is used in the same formula.

I hope you can understand where I am coming from!
Pat





"Dave R." wrote in message
...
=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in the
range
(i.e., "apple" would count also), again for all cells or any one
cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave
cell
empty.






{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))

,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

Of course if there is at least one 0 and one 1 in that range, the formula
will return the same thing.

Each cell in (t24:t1500) contains either "E" or "S" I have changed the
format so it nolonger is a TRUE or FALSE value. Even with this change the
result is the same. Will a different approach be required?



"Dave R." wrote in message
...
You just need to figure out what is actually contained in those cells
(t24:t1500). go to some generally formatted cell and enter =T24 , and see
what comes up. Also see what comes up on cells that are the opposite
(true/false), and use that in the COUNTIF part.

Of course if there is at least one 0 and one 1 in that range, the formula
will return the same thing.




"Pat" wrote in message
...
Here is the formula when adjusted. It does not return a value as
expected,
although there is no errors appearing.



=IF(COUNTIF(PO04!T24:T1500,"E"),IF(ISERROR(INDEX(P O04!$L$24:$L$1500,MATCH(PC


!$H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24 :$L$1500,MATCH(PC!$H8,PO04
!$AI$24:$AI$1500,0))),"")

Because PO04!T24:T1500 is formmated to either TRUE or FALSE ("E" being
TRUE
and "S" being FALSE) when the formula is adjusted to reflect this for
eg.



=IF(COUNTIF(PO04!T24:T1500,1),IF(ISERROR(INDEX(PO0 4!$L$24:$L$1500,MATCH(PC!$


H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24:$ L$1500,MATCH(PC!$H8,PO04!$
AI$24:$AI$1500,0))),"")

a value is returned. The only problem now is that a value will return
for
a
given cell both if 1(one) or 0 (zero) is used in the same formula.

I hope you can understand where I am coming from!
Pat





"Dave R." wrote in message
...
=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in the
range
(i.e., "apple" would count also), again for all cells or any one
cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave
cell
empty.







{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))

,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

Again you must be sure what the content of the cells are. If they are simply
E or S, your formula would work fine. If there is one or more "E" in that
range, it will do the formula, if not it will show a blank.



"Pat" wrote in message
...
Of course if there is at least one 0 and one 1 in that range, the
formula
will return the same thing.

Each cell in (t24:t1500) contains either "E" or "S" I have changed the
format so it nolonger is a TRUE or FALSE value. Even with this change the
result is the same. Will a different approach be required?



"Dave R." wrote in message
...
You just need to figure out what is actually contained in those cells
(t24:t1500). go to some generally formatted cell and enter =T24 , and
see
what comes up. Also see what comes up on cells that are the opposite
(true/false), and use that in the COUNTIF part.

Of course if there is at least one 0 and one 1 in that range, the
formula
will return the same thing.




"Pat" wrote in message
...
Here is the formula when adjusted. It does not return a value as
expected,
although there is no errors appearing.




=IF(COUNTIF(PO04!T24:T1500,"E"),IF(ISERROR(INDEX(P O04!$L$24:$L$1500,MATCH(PC



!$H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24 :$L$1500,MATCH(PC!$H8,PO04
!$AI$24:$AI$1500,0))),"")

Because PO04!T24:T1500 is formmated to either TRUE or FALSE ("E" being
TRUE
and "S" being FALSE) when the formula is adjusted to reflect this for
eg.




=IF(COUNTIF(PO04!T24:T1500,1),IF(ISERROR(INDEX(PO0 4!$L$24:$L$1500,MATCH(PC!$



H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24:$ L$1500,MATCH(PC!$H8,PO04!$
AI$24:$AI$1500,0))),"")

a value is returned. The only problem now is that a value will return
for
a
given cell both if 1(one) or 0 (zero) is used in the same formula.

I hope you can understand where I am coming from!
Pat





"Dave R." wrote in message
...
=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in
the
range
(i.e., "apple" would count also), again for all cells or any one
cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave
cell
empty.








{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))

,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

For the life of me I am sorry but I cannot see how the formula will do what
I want. If the corresponding cell is an "S" and should be an "E" it should
return a blank cell.

If you care to send me a sample workbook of how it works this would be most
welcome. Please email


"Dave R." wrote in message
...
Again you must be sure what the content of the cells are. If they are
simply
E or S, your formula would work fine. If there is one or more "E" in that
range, it will do the formula, if not it will show a blank.



"Pat" wrote in message
...
Of course if there is at least one 0 and one 1 in that range, the
formula
will return the same thing.

Each cell in (t24:t1500) contains either "E" or "S" I have changed the
format so it nolonger is a TRUE or FALSE value. Even with this change
the
result is the same. Will a different approach be required?



"Dave R." wrote in message
...
You just need to figure out what is actually contained in those cells
(t24:t1500). go to some generally formatted cell and enter =T24 , and
see
what comes up. Also see what comes up on cells that are the opposite
(true/false), and use that in the COUNTIF part.

Of course if there is at least one 0 and one 1 in that range, the
formula
will return the same thing.




"Pat" wrote in message
...
Here is the formula when adjusted. It does not return a value as
expected,
although there is no errors appearing.





=IF(COUNTIF(PO04!T24:T1500,"E"),IF(ISERROR(INDEX(P O04!$L$24:$L$1500,MATCH(PC




!$H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24 :$L$1500,MATCH(PC!$H8,PO04
!$AI$24:$AI$1500,0))),"")

Because PO04!T24:T1500 is formmated to either TRUE or FALSE ("E"
being
TRUE
and "S" being FALSE) when the formula is adjusted to reflect this
for
eg.





=IF(COUNTIF(PO04!T24:T1500,1),IF(ISERROR(INDEX(PO0 4!$L$24:$L$1500,MATCH(PC!$




H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24:$ L$1500,MATCH(PC!$H8,PO04!$
AI$24:$AI$1500,0))),"")

a value is returned. The only problem now is that a value will
return
for
a
given cell both if 1(one) or 0 (zero) is used in the same formula.

I hope you can understand where I am coming from!
Pat





"Dave R." wrote in message
...
=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in
the
range
(i.e., "apple" would count also), again for all cells or any
one
cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not
leave
cell
empty.









{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8 ,PO04!$AI$24:$AI$1500,0)))

,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat

I don't understand... You say "... cell is an 'S' and should be an 'E'". A
formula can't "know" that you've made a data entry error unless you build the
logic to do that into the formula.


On Wed, 22 Sep 2004 21:57:09 +0100, "Pat" wrote:

For the life of me I am sorry but I cannot see how the formula will do what
I want. If the corresponding cell is an "S" and should be an "E" it should
return a blank cell.

If you care to send me a sample workbook of how it works this would be most
welcome. Please email


"Dave R." wrote in message
...
Again you must be sure what the content of the cells are. If they are
simply
E or S, your formula would work fine. If there is one or more "E" in that
range, it will do the formula, if not it will show a blank.



"Pat" wrote in message
...
Of course if there is at least one 0 and one 1 in that range, the
formula
will return the same thing.

Each cell in (t24:t1500) contains either "E" or "S" I have changed the
format so it nolonger is a TRUE or FALSE value. Even with this change
the
result is the same. Will a different approach be required?



"Dave R." wrote in message
...
You just need to figure out what is actually contained in those cells
(t24:t1500). go to some generally formatted cell and enter =T24 , and
see
what comes up. Also see what comes up on cells that are the opposite
(true/false), and use that in the COUNTIF part.

Of course if there is at least one 0 and one 1 in that range, the
formula
will return the same thing.




"Pat" wrote in message
...
Here is the formula when adjusted. It does not return a value as
expected,
although there is no errors appearing.





=IF(COUNTIF(PO04!T24:T1500,"E"),IF(ISERROR(INDEX( PO04!$L$24:$L$1500,MATCH(PC




!$H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$2 4:$L$1500,MATCH(PC!$H8,PO04
!$AI$24:$AI$1500,0))),"")

Because PO04!T24:T1500 is formmated to either TRUE or FALSE ("E"
being
TRUE
and "S" being FALSE) when the formula is adjusted to reflect this
for
eg.





=IF(COUNTIF(PO04!T24:T1500,1),IF(ISERROR(INDEX(PO 04!$L$24:$L$1500,MATCH(PC!$




H8,PO04!$AI$24:$AI$1500,0))),"",INDEX(PO04!$L$24: $L$1500,MATCH(PC!$H8,PO04!$
AI$24:$AI$1500,0))),"")

a value is returned. The only problem now is that a value will
return
for
a
given cell both if 1(one) or 0 (zero) is used in the same formula.

I hope you can understand where I am coming from!
Pat





"Dave R." wrote in message
...
=IF(COUNTIF(PO04!T24:T1500,"E"),enter your formula here ,"")




"Pat" wrote in message
...
More than one cell will contain the letter "E"
"E" will have to be alone


"Dave R." wrote in message
...
To clarify -- if ALL cells t24:t1500 contain "E"?
Does "E" have to be alone, or any occurence of "E" anywhere in
the
range
(i.e., "apple" would count also), again for all cells or any
one
cell?


"Pat" wrote in message
...
I want to add to the following formula a condition if
PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not
leave
cell
empty.









{=IF(ISERROR(INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H 8,PO04!$AI$24:$AI$1500,0)))

,"",INDEX(PO04!$L$24:$L$1500,MATCH(PC!$H8,PO04!$AI $24:$AI$1500,0)))}

Thanking you if you can be of help.
Pat