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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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