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,