embarassed to post question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
isnt the "correct orientation shown in sheet 2 any way so you can always
calculate the "span" from the width
 
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
 
You're welcome. Thanks for the feedback!

Biff

Sheaky said:
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
Click to expand...
 
Back
Top