embarassed to post question

sample of 2 worksheets for measuring hurricane shutter
Sheet 1
a b c d
1 window width heigth span
2 1 36 48 vertical
3 2 36 48 horizontal
Sheet 2
a b c
1 window span non span
2 1 36 48
3 2 48 36

the only difference in the two examples is that the run of the fasteners is
in a vert. or horiz. position. is there an argument that will make excel
recognize that the width might be either the span or non-span of the window
depending on which direction sheet 1 column d stipulates? For example, can I
get it to state that the span of the shutter is the height if the fasteners
run vertically, or the span is the width if they run horizontally? This is
probably simple for ya'll, or I might not be providing enough info. Any help
would be greatly appreciated, if this works, ill be switching my entire
estimating forms to EXCEL from ink and paper. Thanks

Hi!

You can use a lookup formula to lookup the window number and return the
span: (V or H)

Based on your limited sample, enter this formula in Sheet2 D2:

=VLOOKUP(A2,Sheet1!A$2:D$3,4,0)

Then you'd just drag copy down as needed.

This seems kind of redundant to me since you already have all the info you
seem to need on Sheet1.

Biff

"Sheaky" <Sheaky@discussions.microsoft.com> wrote in message
news:96DEDAEC-00A3-4A54-87E8-762B731A51DA@microsoft.com...
> sample of 2 worksheets for measuring hurricane shutter
> Sheet 1
> a b c d
> 1 window width heigth span
> 2 1 36 48 vertical
> 3 2 36 48 horizontal
> Sheet 2
> a b c
> 1 window span non span
> 2 1 36 48
> 3 2 48 36
>
> the only difference in the two examples is that the run of the fasteners
> is
> in a vert. or horiz. position. is there an argument that will make excel
> recognize that the width might be either the span or non-span of the
> window
> depending on which direction sheet 1 column d stipulates? For example, can
> I
> get it to state that the span of the shutter is the height if the
> fasteners
> run vertically, or the span is the width if they run horizontally? This
> is
> probably simple for ya'll, or I might not be providing enough info. Any
> help
> would be greatly appreciated, if this works, ill be switching my entire
> estimating forms to EXCEL from ink and paper. Thanks
>
>
>
>

isnt the "correct orientation shown in sheet 2 any way so you can always
calculate the "span" from the width
--
paul
remove nospam for email addy!



"Sheaky" wrote:

> sample of 2 worksheets for measuring hurricane shutter
> Sheet 1
> a b c d
> 1 window width heigth span
> 2 1 36 48 vertical
> 3 2 36 48 horizontal
> Sheet 2
> a b c
> 1 window span non span
> 2 1 36 48
> 3 2 48 36
>
> the only difference in the two examples is that the run of the fasteners is
> in a vert. or horiz. position. is there an argument that will make excel
> recognize that the width might be either the span or non-span of the window
> depending on which direction sheet 1 column d stipulates? For example, can I
> get it to state that the span of the shutter is the height if the fasteners
> run vertically, or the span is the width if they run horizontally? This is
> probably simple for ya'll, or I might not be providing enough info. Any help
> would be greatly appreciated, if this works, ill be switching my entire
> estimating forms to EXCEL from ink and paper. Thanks
>
>
>
>

Biff,
Thanks for your help. I am a new user and am still unfamiliar with all
excel can do. Your right, in the limited sample, it does seem redundant.
However, there is a third and fourth worksheet. Sheet 1 is going to be
strictly the window measurements and in which direction the fasteners will
run for certain shutter applications. Sheet 2, 3 and 4 will be different
types of shutters. Sheet 2 and 3 will require the span information because
it might change, but the 4th sheet information won't require the span because
it will always be horizontal (accordion shutters).
Your help seems to be the answer though. I appreciate it VERY much. I'm
getting tired of reentering the same information manually (literally, ink and
paper), and I hope with the help of ppl like you, ill figure this out.
Thanks, Thanks and Thanks again

"Biff" wrote:

> Hi!
>
> You can use a lookup formula to lookup the window number and return the
> span: (V or H)
>
> Based on your limited sample, enter this formula in Sheet2 D2:
>
> =VLOOKUP(A2,Sheet1!A$2:D$3,4,0)
>
> Then you'd just drag copy down as needed.
>
> This seems kind of redundant to me since you already have all the info you
> seem to need on Sheet1.
>
> Biff
>
> "Sheaky" <Sheaky@discussions.microsoft.com> wrote in message
> news:96DEDAEC-00A3-4A54-87E8-762B731A51DA@microsoft.com...
> > sample of 2 worksheets for measuring hurricane shutter
> > Sheet 1
> > a b c d
> > 1 window width heigth span
> > 2 1 36 48 vertical
> > 3 2 36 48 horizontal
> > Sheet 2
> > a b c
> > 1 window span non span
> > 2 1 36 48
> > 3 2 48 36
> >
> > the only difference in the two examples is that the run of the fasteners
> > is
> > in a vert. or horiz. position. is there an argument that will make excel
> > recognize that the width might be either the span or non-span of the
> > window
> > depending on which direction sheet 1 column d stipulates? For example, can
> > I
> > get it to state that the span of the shutter is the height if the
> > fasteners
> > run vertically, or the span is the width if they run horizontally? This
> > is
> > probably simple for ya'll, or I might not be providing enough info. Any
> > help
> > would be greatly appreciated, if this works, ill be switching my entire
> > estimating forms to EXCEL from ink and paper. Thanks
> >
> >
> >
> >
>
>
>

You're welcome. Thanks for the feedback!

Biff

"Sheaky" <Sheaky@discussions.microsoft.com> wrote in message
news:1A46462F-DFBA-452E-9B28-8EFC1E50EBC6@microsoft.com...
> Biff,
> Thanks for your help. I am a new user and am still unfamiliar with all
> excel can do. Your right, in the limited sample, it does seem redundant.
> However, there is a third and fourth worksheet. Sheet 1 is going to be
> strictly the window measurements and in which direction the fasteners will
> run for certain shutter applications. Sheet 2, 3 and 4 will be different
> types of shutters. Sheet 2 and 3 will require the span information
> because
> it might change, but the 4th sheet information won't require the span
> because
> it will always be horizontal (accordion shutters).
> Your help seems to be the answer though. I appreciate it VERY much. I'm
> getting tired of reentering the same information manually (literally, ink
> and
> paper), and I hope with the help of ppl like you, ill figure this out.
> Thanks, Thanks and Thanks again
>
> "Biff" wrote:
>
>> Hi!
>>
>> You can use a lookup formula to lookup the window number and return the
>> span: (V or H)
>>
>> Based on your limited sample, enter this formula in Sheet2 D2:
>>
>> =VLOOKUP(A2,Sheet1!A$2:D$3,4,0)
>>
>> Then you'd just drag copy down as needed.
>>
>> This seems kind of redundant to me since you already have all the info
>> you
>> seem to need on Sheet1.
>>
>> Biff
>>
>> "Sheaky" <Sheaky@discussions.microsoft.com> wrote in message
>> news:96DEDAEC-00A3-4A54-87E8-762B731A51DA@microsoft.com...
>> > sample of 2 worksheets for measuring hurricane shutter
>> > Sheet 1
>> > a b c d
>> > 1 window width heigth span
>> > 2 1 36 48 vertical
>> > 3 2 36 48 horizontal
>> > Sheet 2
>> > a b c
>> > 1 window span non span
>> > 2 1 36 48
>> > 3 2 48 36
>> >
>> > the only difference in the two examples is that the run of the
>> > fasteners
>> > is
>> > in a vert. or horiz. position. is there an argument that will make
>> > excel
>> > recognize that the width might be either the span or non-span of the
>> > window
>> > depending on which direction sheet 1 column d stipulates? For example,
>> > can
>> > I
>> > get it to state that the span of the shutter is the height if the
>> > fasteners
>> > run vertically, or the span is the width if they run horizontally?
>> > This
>> > is
>> > probably simple for ya'll, or I might not be providing enough info.
>> > Any
>> > help
>> > would be greatly appreciated, if this works, ill be switching my entire
>> > estimating forms to EXCEL from ink and paper. Thanks
>> >
>> >
>> >
>> >
>>
>>
>>