Please see http://nzcargoops.com/np.xls for excel sheet.

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$3 :$B$61),C21MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATCH ($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote:

Please see http://nzcargoops.com/np.xls for excel sheet.

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$ 3:$B$61),C21MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATC H($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:


....MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron

On Apr 13, 10:10 pm, Ron Rosenfeld wrote:
On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote:





Please seehttp://nzcargoops.com/np.xlsfor excel sheet.

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$ 3:$B$61),C21MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATC H($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:

...MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron- Hide quoted text -

- Show quoted text -

Ron,

you are absuletly right, It is working like charm
Thanks,

On 14 Apr 2007 07:11:10 -0700, "turkyildiz" wrote:

On Apr 13, 10:10 pm, Ron Rosenfeld wrote:
On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote:





Please seehttp://nzcargoops.com/np.xlsfor excel sheet.

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$ 3:$B$61),C21MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATC H($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:

...MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron- Hide quoted text -

- Show quoted text -

Ron,

you are absuletly right, It is working like charm
Thanks,


You're welcome. Glad to help. We've been to NZ once -- and didn't stay long
enough. Maybe we'll be back for a longer stay some day.
--ron

On Apr 14, 10:34 am, Ron Rosenfeld wrote:
On 14 Apr 2007 07:11:10 -0700, "turkyildiz" wrote:



On Apr 13, 10:10 pm, Ron Rosenfeld wrote:
On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote:

Please seehttp://nzcargoops.com/np.xlsforexcel sheet.

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$ 3:$B$61),C21MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATC H($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:

...MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron- Hide quoted text -

- Show quoted text -

Ron,

you are absuletly right, It is working like charm
Thanks,

You're welcome. Glad to help. We've been to NZ once -- and didn't stay long
enough. Maybe we'll be back for a longer stay some day.
--ron

Ron,

On more question formula fixed but know very simple argument like 48 x
48 x 48 shows no and the answer should read yes.

On 14 Apr 2007 10:29:23 -0700, "turkyildiz" wrote:

On Apr 14, 10:34 am, Ron Rosenfeld wrote:
On 14 Apr 2007 07:11:10 -0700, "turkyildiz" wrote:



On Apr 13, 10:10 pm, Ron Rosenfeld wrote:
On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote:

Please seehttp://nzcargoops.com/np.xlsforexcel sheet.

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$ 3:$B$61),C21MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATC H($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:

...MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron- Hide quoted text -

- Show quoted text -

Ron,

you are absuletly right, It is working like charm
Thanks,

You're welcome. Glad to help. We've been to NZ once -- and didn't stay long
enough. Maybe we'll be back for a longer stay some day.
--ron

Ron,

On more question formula fixed but know very simple argument like 48 x
48 x 48 shows no and the answer should read yes.

Could there be a problem with your data table? The one you show on the
downloaded worksheet only as a few "2500's" filled in, and the rest is zero.
The sheet is protected so I cannot change it.
--ron